Thread: Help With Sumif

Hi I have the following formula and I want it to just find "January" in the range as they have 1st January, "2nd January and so on. So if it finds a cell with January in it, it includes it.


=SUMIF(C10:C700,"January",F10:F700)

Many thanks


David

If the range C10:C700 contains actual Text strings (not Date values (numbers)) and year etc is irrelevant:

=SUMIF(C10:C700,"*January*",F10:F700)

If though they are date values formatted then if the year etc is irrelevant perhaps:

=SUMPRODUCT(--(C10:C700<>""),--(TEXT(C10:C700,"mm")="01"),F10:F700)

If in doubt - best to post a sample so we can see what you're working with exactly

Many thanks the first option works.