Do you mean that you have a number of tabs and want to get the total of all the SUMIF calcs across all tabs?
ie SUMIF(tab1...) + SUMIF(tab2...) +....
Then you could do it the way youve said ie like above or I believe (but dont quote me) that you may be able to do something with SUMPRODUCT or an Array Formula
If someone has helped you then please add to their Reputation
Thank you pjwhitfield. I have a summary tab that this formula would be on because I am looking for a reference on a column and a row. These references are on all 13 tabs so I would like the summary sheet to look at the column ref and the row reference (not necessarily on the same column or row) in each tab and sum the total value. Does that make sense?
I just thought there would be an easier way than having that formula for every tab with +......+....
If the data was in the same column on each sheet then you could use a more compact formula rather than doing:=SUMIF('1-April '!$A$2:$A$600,$A4,INDEX('1-April '!$E$2:$Q$2,MATCH(E$2,'1-April '!$E$2:$Q$2,0)))
=Formula1+Formula2+Formula3 etc., etc.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Well I would rather not do the above because if the data was moved (as the sheet is populated by various people) then the formula on the summary sheet would still pick all the data up despite its column and row having been changed if that makes sense? I wanted to know that no matter where the data was on the tab as long as the formula on the Summary sheet was looking up the column header and row header it would add in the value. Plus I'm sure it can be done and trying to widen my knowledgeOriginally Posted by Tony Valko
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks