You could try:
=SUMIF($C$2:$C$21,"<=03/31/06",$AL$2:$AL$21)-SUMIF($C$2:$C$21,"<01/01/06",$AL$2:$AL$21)
Format as general.

Hope this helps
Rowan


Jeremy Ellison wrote:
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....?