help! on sumif w/ date using multiple criteria

Hi Guys,

Can anyone help me with the function sumif with date text and date criteria.

A B C D

A1 2/5/06 5

B1 2/10/06 6

A1 2/8/06 7

A1 1/5/05 3

B1 3/10/06 2

I need to sum all A1 that falls under the month of february. This is just as sample, the real file is 5000 long. How can I do that using sumif or using other function. I'm out of ideas here.

Any guys have experience on this?

Originally Posted by japorms

Hi Guys,

Can anyone help me with the function sumif with date text and date criteria.

A B C D

A1 2/5/06 5

B1 2/10/06 6

A1 2/8/06 7

A1 1/5/05 3

B1 3/10/06 2

I need to sum all A1 that falls under the month of february. This is just as sample, the real file is 5000 long. How can I do that using sumif or using other function. I'm out of ideas here.

Any guys have experience on this?

=SUMPRODUCT(--(A2:A6="A1"),--(MONTH(B2:B6)=2),(C2:C6))

all your ranges (i.e. a2:a6, b2:b6) must be the same length

Try

=SUMPRODUCT(--(MONTH($B$1:$B$15000)=2)*(--($A$1:$A$15000="A1")*(--($C$1:$C$15000))))

Change range as required

VBA Noob