Sum data over multiple worksheets based on month criteria.

I am trying to summarize data from multiple worksheets based on the column month. There are only 6 columns in each Lot tab but the months of those columns may change based on the start date of the project. There is a sheet list on the summary tab. When I do an evaluation of the formula, the sheets show #VALUE and I only get 0 for a sum.

You don't need check month of the date just the date itself.

=SUMPRODUCT(SUMIF(INDIRECT("'"&$B$53:$B$70&"'!$i$8:$n$8"),E$27,INDIRECT("'"&$B$53:$B$70&"'!$i$59:$n$59")))

The month is the key because start dates can be different days of the month. I found a solution by making a formula below the data in the Lot tabs that reads only the month. Then I use that as the criteria range for the criteria to match and it works across all lots and months.

If your are summing any month (then to me) the start date is not relevant. If all month headings had a date of 01/mm/yyyy and data in the column was only for that month, then checking the month simply by matching the 01 date will work.

Everything in your sheet supports this - but your choice.

It seemed to be reading the entire date instead of just the month so this works. Maybe not perfect but now I can move forward to finish the rest of the project and not spin my wheels on it.

I got my other problem solved I think but your change does shorten those formulae.

Thanks.