Simplest way? Have a separate sum on each worksheet, and then just that cell
across all worksheets.

--
__________________________________
HTH

Bob

"chickalina" wrote in message
...
I have a worksheet that has 8 tabs. Each row is a work order to do work in
a
building. Each tab has two or three buildings. I want to be able to
calculate
the total value (column G) for each work order, by building (column D), by
date (column I). The dates are daily. I need to create a worksheet that
calculates what we are spending on each building. This is a running report
that is added to daily and this report will need to be accurate to the end
of
the year...... can someone help?
M