Sumif - Multiple Sheets
Hi all
How can I sumif over multiple tabs?? Without using sumif(a:a,sheet1!a1,c:c)+sumif(a:a,sheet2!a1,c:c)
Like sumif(sheet1:sheet2!a:a,a1,sheet1:sheet2!c:c) I do not want to use a macro. I have about 80 sheets.
Sheet1
Apples 93
Pears 49
Oranges 20
Bananas 35
Sheet2
Apples 100
Pears 13
Oranges 2
Bananas 350
Many thanks
Please take a few minutes and read the ForumRules about cross posts.
Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.
It is preferred that you not cross-post at all, but if you do, please provide a link to the cross-post
As a footnote to the other post, with 80 sheets it might be easier to perform a Sumif on every sheet
E1 =SUMIF(A:A,A1,C:C)
and then on the summary page or wherever
=SUM(Sheet1:Sheet2!E1)
Last edited by jeffreybrown; 05-21-2012 at 06:48 PM.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks