Sumif "today()"
 

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

Sumif "today()"
 

Think it should be:
=SUMIF($A$3:$A$47,"<="&TODAY(),$D$3:$D$47)

Above tested ok. Punch YES to celebrate your success.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Ken King" wrote:
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

Sumif "today()"
 

Ken King wrote:
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 &)