SUMIF problem

W

wahur

Column A has dates
Column S has numbers
I need to add numbers in rows where date is in past.
I tried
Code
-------------------
=SUMIF(A:A;"<today()";S:S
-------------------
and got 0 for an answer
I put
Code
 
S

SteveG

Wahur,

Change your original to:

=SUMIF(A:A,"<"&TODAY(),S:S)

You had quotes around the TODAY function which caused your problem.

HTH

Steve
 
Top