Is there an easy way to sum specific items from multiple worksheets - I've tried SUMIF and SUMIFS, but don't know what I'm doing wrong...
Is there an easy way to sum specific items from multiple worksheets - I've tried SUMIF and SUMIFS, but don't know what I'm doing wrong...
I don't think your maths is right, but try this:
Please Login or Register to view this content.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
In "Total" Sheet in cell "B2" formula :
=SUMIF(CW!$A$4:$A$15,A2,CW!$B$4:$B$15)+SUMIF(FHW!$A$4:$A$23,A2,FHW!$B$4:$B$23)+SUMIF(GJEC!$A$4:$A$31,A2,GJEC!$B$4:$B$31)+SUMIF(Koko!$A$4:$A$24,A2,Koko!$B$4:$B$24)
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There is no need for the sheet reference in the first SUMIF because the formula is on the same sheet. Apart from this, your suggestion is identical to mine.
Try
=SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets&"'!$A$2:$A$100"),A2,INDIRECT("'"&Sheets&"'!$B$2:$B$100")))
Sheets is a named range with list of Tabs
CW
FHW
GJEC
KoKo
Using SUMIF the ranges need to be aligned: otherwise you will get wrong results: make the criteris and sum ranges have same limits:
e.g. A2:A30 and B2:B30
Last edited by JohnTopley; 11-12-2016 at 08:32 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks