Sumif for multiple tabs

G

Guest

I am trying to sum my salary expense from multiple tabs. Not all the tabs
have salary expense and they are on different lines. I tried doing a sumif
function but it won't work for multiple tabs...any ideas?
 
G

Guest

How about:

=sumif(sheet1!A:A,"Salary Expense",sheet1!B:B)+sumif(sheet2!A:A,"Salary
Expense",sheet2!B:B)+sumif(sheet3!A:A ... etc
 
R

Roger Govier

Hi Brad

One way would be to do a SUMIF on each sheet in a constant location.
Then your summary would be
=SUM(Sheet1:Sheet12!$X$1)
changing the reference as appropriate.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif to multiple tabs 1
Sum by Cost Center 2
vlookup, if ?????? 1
problem with excel logic, too complicated of a function set??? 3
Using Sumif on multiple tabs 1
Using 'AND' logic in a SUMIF statement 2
Pivot tables, IF statements, vlookups? 2
Sum on multiple columns with search criteria 6

Top