Example.xlsx
Attached is an example of the data sheet I have. I am trying to sum the values in column C for each of the distinct products listed in column B (ex: Programmable Thermostat total is 30, EnergyStar Refrigerator total is 25, etc)
Not sure if I'm just trying to make it more complicated than it needs to be, but my attempts with SUMPRODUCT have not been successful. Any helpful suggestions out there?
Last edited by undoubtedlymegz; 03-07-2013 at 04:30 PM.
Try
=SUMIF($B$2:$B$6,B2,$C$2:$C$6)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes, it does! Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks