Formula with @ in cell

Closed
-
Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
-
Hello,

Could someone please let me know if there is a formula to get a total if row 4, column D is 8 @ 2000 and row 6, column D is 9 @ 2000.
The total should equal 17.
I want to reference Column B, all items that are salt, and Column D 8 @ 2000.
Hope this helps.

I appreciate your time in helping me resolve this problem.

Thank you for your support.


1 reply

Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
491
Hi Judy,

Not sure what it exactly is you are looking for, but if you want to add
D4: 8 @ 2000 with D6: 9 @ 2000 to get a result of 17 then the following formula will do the job:
=SUM(LEFT(D4,SEARCH(" ",D4)-1),LEFT(D6,SEARCH(" ",D6)-1))

Please clarify you query if this is not the answer you were hoping for.

Best regards,
Trowa