Formula with @ in cell

Closed
judy - Apr 13, 2015 at 08:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 14, 2015 at 12:04 PM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 14, 2015 at 12:04 PM
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
0