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?