Formula with @ in cell

[Closed]
Report
-
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
-
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
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
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