Sumif same cell on sheets based on month

Hi JDR,

How do I explain this nicely?? You have discovered that the way you set up your data makes a difference. Excel works best if you collect data in a TABLE. That is an area of cells with no blank rows or columns. Each column head needs a name and each row is a record of data. You decided to put each week(s) on a different tab and duplicate the layout. Now a formula to gather all the sheets data into a single number is too hard (I saw your formula that is HUGE).

If you reorganized your data in a better TABLE format you could filter and sort and even graph the data much better.

I'd make the first column a Labor Column that could have an Employee Name or Casuals (?) or M&I name or Student Name.
The second column head would be Date (Pay date or date of transaction)
The next column heads would be like you have on row 4 starting at column C of your sheets.

I'd make all this data into a single table on a single sheet. Then I'd use filters and sorts or Pivot Tables to give you the answers you need. Pivot Tables doen't need formulas...

https://support.office.com/en-us/art...9-F99134456576