Hi all,
I'm working on a spreadsheet at work and I'm trying to sum only the values in a column that meet criteria in the column next to it. For example, in the attached spreadsheet, I would like to have a totals line at the bottom of the spreadsheet for all three Facilities and the total next to them. I know I could do a pivot table but I know this approach would be more aesthetic and easier for my supervisor.
Thanks for the help!
If you already have the unique locations....
Facility 1 Facility 2 Facility 3
B26=SUMIF($A$2:$A$22,A26,B2:$B$22)
copied down
If you dont have unique locations, use this...
A26=IFERROR(INDEX($A$2:$A$22,MATCH(0,INDEX(COUNTIF($A$25:A25,$A$2:$A$22),0,0),0)),"")
copied down
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
Wow, that worked like a charm. Thanks so much!
Sorry, there waqs an error in that 1st formula (left out a $). If should have been...
=SUMIF($A$2:$A$22,A26,$B$2:$B$22)
IF you want the sumproduct equivalent....
=SUMPRODUCT(($A$2:$A$22=A26)*($B$2:$B$22))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks