SUMIF

A

Amy

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

Thanks! Amy
 
J

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
 
R

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
 
A

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!
 
R

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!
 
Top