Summing based on values in other worksheets

[chickalina]

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

 

[Bob Phillips]

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

 

[chickalina]

Thanks for the suggestion, but that will take quite a bit of time....
Is there a way to write the following:
If Sheet1 Column D=37 and Sheet1 Column I is between January 1, 2009 and
January 31, 2009, then add Sheet1,ColumnG, and so on for each month.
Something like that?