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 total from the items and add them together to come up with a total cost of the contributions. If anyone can help I would greatly appreciate it.
Thanks,
Mark Arling
2 Replies
Mark_Arling_285not sure if you only need total, but in case you need % contribution by each item i also list on the side.
i also added iferror formula in front so as to eliminate any possibilities of errors.
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.
