SumIf dates...month & year!

I am looking to sum if a range of dates.

Ideally i would like this to be as generic as possible, i.e if the list of dates changes the formula adapts.

On my file you will see Branch totals. I would like to then break down values for each month and in what year.

I have looked around but cent see that fits this exactly...

Would be great if you could help out.

Thanks

Ross

example.xlsx

Hi Ross Ink,

Hope this attached excel file will help you.

I have Added in column J1 to Q19, calculation of the branch by month using SUMIFS function.
For example in N2, formula is

Formula:

Please Login or Register  to view this content.

It is just stated that Sum range G21 to G1032 when it satisfy 3 criteria
1 being the Date J2, has to be greater than equal to J2 in range F21 to F1032 and
2 has to be less than equal to the last day of month J2 (using EOMONTH function) and
3 sum when A21 to A1032 satisfy the condition of branch 72.

However I would suggest you to use pivot table to summarise as this will reduce human error. I have created a pivot table for you in another sheet. look at it whether that would suit you?

Cheers
Albert


Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

Guys thank you!

Both example are much appreciated.

Is there in anyway that you don't need to "hard wire" the date?? In where you look at the list of dates, split into months then show sum of total.

Thanks

Ross