Hi,
I have searched and can't seem to find a solution that works for me. Basically I have to sum up a column based on criteria in 2 other columns to provide summary information.
For example: Sum Column B where column A = Hardware AND column C = BB
I have attached a workbook with an example. Expected results are on the "summary" sheet.
Thanks in advance for any help. I know this is probably fairly simple but I am drawing a blank for some reason.
Brian
Last edited by BarnesB; 09-27-2011 at 01:38 PM.
See attached.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
In B2:
=SUMIFS(Data!$B$2:$B$19,Data!$A$2:$A$19,A2,Data!$C$2:$C$19,$B$1)
copied down.
you will need to adjust the $B$1 reference in the other subtables.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks, that solved the issue!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks