SUMIF

[Amy]

I have one column with dates and another column with
currency. How can I total the currency for a particular
month?

Thanks! Amy

 

[Don Guillett]

try
=sumproduct((month(a2:a200=5)*b2:b500)

 

[Don Guillett]

Oops. forgot a parenthesis.
=sumproduct((month(a2:a200)=5)*b2:b500

 

[Jason Morin]

SUMIF is not robust enough in this case. But this'll work:

=SUMPRODUCT((TEXT(A1:A20,"mmm")="Jun")*B1:B20)

where dates are in col. A and currency in col. B.

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2004),B1:B100)

 

[RagDyeR]

With dates in column A, currency in column B, enter the number of the month
to lookup in C1, and try this formula:

=SUMPRODUCT((MONTH(A2:A100)=C1)*B2:B100)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I have one column with dates and another column with
currency. How can I total the currency for a particular
month?

Thanks! Amy

 

[Amy]

Thanks! This works for a range from A5:A350 but it
doesn't work for my range from A5:A900. How do I also
incorporate the year?

Thanks for the help!

 

[RagDyeR]

Try this, with number of month to lookup in C1, and year to lookup in D1:

=SUMPRODUCT((MONTH(A5:A900)=C1)*(YEAR(A5:A900)=D1)*B5:B900)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Thanks! This works for a range from A5:A350 but it
doesn't work for my range from A5:A900. How do I also
incorporate the year?

Thanks for the help!

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(MONTH(A5:A900)=5),--(YEAR(A5:A900)=2004),B5:B900)