Dear Excel Forum,
I am once again faced with the situation that only you can help me!
What I need is a solution that picks up a value if: Col B = "Sep" & Col C = "Penalty".
Currently I just have a sumIf function that gets the totals from the columns, but i need it to be allocated to the correct month.
It might just be a matter of nesting the sumIf functions in a neat way?
Please find the spreadsheet with further explanation kindly attached.
Many Thanks!
Pete
Bookmarks