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:
=SUMIFS($G$21:$G$1032,$F$21:$F$1032,">="&J2,$F$21:$F$1032,"<="&EOMONTH(J2,0),$A$21:$A$1032,$N$1)
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).
Bookmarks