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
=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