SumIf

[Manuel]

I have 2 columns of which one column contains dates and
the second contains values. I need to sum the values if
the date is less than 2 days from today. Sample Data:

Column A Column B
06/12/04 3
06/30/04 4
07/09/04 5

The total for today (07/09) should be 7.

Any help is appreciated.
Thanks,
Manuel

 

[Frank Kabel]

Hi
try
=SUMIF(A1:A100,"<" & TODAY()-2,B1:B100)

 

[Don Guillett]

try
=SUMIF(A1:A3,"<"&TODAY()-2,B1:B3)

 

[Guest]

Thanks, that did it.

-----Original Message-----
Hi
try
=SUMIF(A1:A100,"<" & TODAY()-2,B1:B100)

--
Regards
Frank Kabel
Frankfurt, Germany


.