Sumif for multiple tabs
 

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?

Sumif for multiple tabs
 

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


--
Allllen


"Brad" wrote:

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?

Sumif for multiple tabs
 

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.

--
Regards

Roger Govier


"Brad" wrote in message
...
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?