Use of Month() within SumIF()

[Paul Vespermann]

I have a formula problem related to the use of the
function month(). My data spreadsheet contains multiple
columns 2 of which are Date & Sales. I am trying to
export to another sheet the sum of each months sales using
the formula sumif(range,month(),range. The month()
formula refers to a cell with an interger from 1-12
corresponding to the month I want total sales summed for
i.e. sumif(range,month(3),range) for March. Myh answer
always comes up 0. What am I doing wrong. I realize
there are other ways of accomplishing this (pivot tables,
additional columns etc.), however, this works best for my
purposes.

 

[Bob Phillips]

Paul,

Try SUMPRODUCT
=SUMPRODUCT((MONTH(A1:A100)=5)*(B1:B100))