SUMIF function

[James Johnson]

I am trying to use SUMIF function with Excel X, Mac OS
10.2.6 . I want to sum those amounts in col B which have
dates in col A that match the month being summed. E.g.
January 5, 2004, January 7, 2004, November 15, 2004. How do
I set the criteria to recognize the month from within the
date? Thanks James Johnson

 

[J.E. McGimpsey]

I am trying to use SUMIF function with Excel X, Mac OS
10.2.6 . I want to sum those amounts in col B which have
dates in col A that match the month being summed. E.g.
January 5, 2004, January 7, 2004, November 15, 2004. How do
I set the criteria to recognize the month from within the
date? Thanks James Johnson

One way:

If the month (as 1 - 12) is in C1 then

=SUMPRODUCT(--(MONTH(A1:A1000)=C1),B1:B1000)

This will sum numbers from January of any year. If you want to limit
the sum to January of a particular year (say in C2):

=SUMPRODUCT(--(MONTH(A1:A1000)=C1),--(YEAR(A1:A1000)=C2),B1:B1000)