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....?