Sumif ">today()"

K

Ken King

Here is my formula:

=SUMIF($A$3:$A$47,"=<today()",$D$3:$D$47)

I am try to sum column D if the date in column A is equal to or less than
today. My date column has valid dates (formated as date) from 2005 to 2018
and all rows in column D have valid numbers, yet this formula returns 0. I
have tried with and without the equal sign and brackets. Any suggestions?
Ken
 
S

smartin

Ken said:
Here is my formula:

=SUMIF($A$3:$A$47,"=<today()",$D$3:$D$47)

I am try to sum column D if the date in column A is equal to or less than
today. My date column has valid dates (formated as date) from 2005 to 2018
and all rows in column D have valid numbers, yet this formula returns 0. I
have tried with and without the equal sign and brackets. Any suggestions?
Ken

Try
=SUMIF($A$3:$A$47,"=<"&TODAY(),$D$3:$D$47)

(note " and &)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top