I need to get a total cost of goods for each supplier. The example spreadsheet shows supplier in column A, prices in column B. How do I get a formula that can automatically sum the prices for each supplier? Desired output is in column C
thanks!
I need to get a total cost of goods for each supplier. The example spreadsheet shows supplier in column A, prices in column B. How do I get a formula that can automatically sum the prices for each supplier? Desired output is in column C
thanks!
Last edited by Ocean Zhang; 08-05-2013 at 06:49 PM.
Put
=SUMIF(A:A, A2, B:B) in C2 and drag down.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
If you want the total only shown once, try this, copied down...
=IF(COUNTIF($A$2:A2,A2)>1,"",SUMIF($A$2:$A$34,A2,$C$2:$C$34))
If you want the total shown against each row, use this, copied down...
=SUMIF($A$2:$A$34,A2,$C$2:$C$34)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
both worked. thanks!!!
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks