"garlocd" wrote:
I need to be able to sum one column based on dates in another column.
One way ..
Assuming real dates are within $A$2:$A$100,
with values to be summed in $B$2:$B$100
Try something like this in say, C1:
=SUMPRODUCT(($A$2:$A$100= -- "1-Jun-2006")*($A$2:$A$100<= --
"15-Jun-2006"),$B$2:$B$100)
Adapt to suit, but note that entire col references eg: A:A, B:B, cannot be
used in SUMPRODUCT
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---