Set date in row 10 as excel dates and format as "mmmm"
in D11
=SUMIFS($F$3:$F$7,$B$3:$B$7,">=" &D$10,$B$3:$B$7,"<=" & EOMONTH(D$10,0),$E$3:$E$7,$C11)
Copy across and down
Set date in row 10 as excel dates and format as "mmmm"
in D11
=SUMIFS($F$3:$F$7,$B$3:$B$7,">=" &D$10,$B$3:$B$7,"<=" & EOMONTH(D$10,0),$E$3:$E$7,$C11)
Copy across and down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks