Forum Discussion
I need to take quantity and multiply it by cost then total the complete cost
I am trying to create an excel sheet where I am taking the quantity of an item I have and multiply it by the estimated purchased price to come up with a total for an item. Then I would like to the t...
Hi Mark,
Please try this...
In E2
=IF(OR(C2="",D2=""),"",C2*D2)
and then copy it down.
In D15
=SUM(E2:E13)
Please find the attached with the formulas in place and let me know if this is what you were trying to achieve.