=SUMIF(A:A,"="&BE38,C:C)

and

=SUMIF(A:A,"="&BE39,C:C)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Nan" wrote in message
...
I could use your help to sum a range if a condition is met. I'm trying to
calculate the number of units sold in the last 6 months and the last 8
weeks.

Here's my worksheet layout:

C1: =now()

A10:C22 as follows
Col A Col B Col C
Jan-2007 2007 2
Feb-2007 2007 -1
Mar-2007 2007 0
Apr-2007 2007 0
May-2007 2007 0
Jun-2007 2007 0
Jul-2007 2007 0
Aug-2007 2007 0
Sep-2007 2007 0
Oct-2007 2007 1
Nov-2007 2007 0
Dec-2007 2007 0
Jan-2008 2008 0

B38: =DATE(YEAR($C$1),MONTH($C$1)-6,DAY(1)) -- 6 months from today
B39: =DATE(YEAR($C$1),MONTH($C$1)-2,DAY(1)) -- 2 months from today

I'm stuck trying to evaluate the condition, then summing only those units
sold in Col C within the specified time frame.

--
TIA, Nan