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?