SUMIF problem

[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

 

[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

 

[wahur]

Thanks, works perfect!

Wahur