SUMIF criteria

[Creosoter]

I have a column with dates entered as m/dd/yy.

I have another column with revenue.

I need a formula for sumif that will only sum revenues for the specified month.

Thanks in advance for your help.

[#2]

Instead of a formula use a pivot table.

[#3]

@Creosoter

Let's say the dates are in D2:D100 and the revenue in E2:E100.

Cell K1 contains a date in the month you want to look at.

=SUMIFS(E2:E100, D2:D100, ">"&EOMONTH(K1, -1), D2:D100, "<="&EOMONTH(K1, 0))