SUMIF with month criteria

[lallo.jr]

Hello,

I would like to set up a simple sumif formula that adds numbers from column c (C3:C10000) when the corresponding date in column a (A3:A10000) meets a month name criteria (preferably in three letter format - "mmm")

I am unsure how to construct the correct formula ... I bet you're not though!

Thanks for your help.

[Paul]

Hi Lallo.jr, perhaps try:

=SUMPRODUCT((TEXT(A1:A6,"mmm")="feb")*C1:C6)

Where A1:A6 have dates (or even dates formatted as "mmm" already). If A1:A6 has actual text "jan", "feb", etc., you can use just

=SUMPRODUCT((A1:A6="feb")*C1:C6)