Sum If by month

[keithabailey]

I need to be able input a range (i.e. B2:D7) and sumif based on row AND column, but cannot work out how to do this with sumif. The output should be like rows 11 to 14. Any help would be appreciated.

[contaminated]

Actually u can use this formula

=SUM(INDEX(($A11=$A$2:$A$7)*(B$10=$B$1:$D$1)*($B$2:$D$7),0))

But yours is also works
Or ekse, think u can use Pivot Table Report... See related tutorials

[keithabailey]

Thats great. Thanks for your help.

[squiggler47]

Try this :-

=SUMPRODUCT(($A11=$A$2:$A$7)*$B$2:$D$7*(B$10=$B$1:$D$1))

copied into cells b11:d14 will generate the table!