Add numbers in column b if date is between certain criteria
Try this:
=SUMPRODUCT((C2:C1000=DATE(2006,1,1))*(C2:C1000<= DATE(2006,3,31))*AL2:AL1000)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jeremy Ellison" wrote in message
...
I want to add a column of numbers (column AL, which contains #.# Grams) if
column C (dates) is between a range of dates (ie. between 1/1/06 and
3/31/06).
I could use sumproduct if it was text, to count the number of occurrances
of
a certain text, but how to I get it to add numbers....?
|