So, I've managed to get the sumif to work, using cells matching to total the sum up, but I can't seem to get it to work, so I can separate by months.
Then I can just punch in the date, the amount and using a drop down, choose the reason, and it will work it out on the right hand side.
The formula I currently have is '=SUMIF(D:D,"*"&H2&"*",C:C)' [H2, I2, ... is the reason to match column D, the values I have in column C, ignore the notes]
is there a way to tweak the formula to separate based on date too?
Example.PNG
Bookmarks