| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "NOW" or "TODAY" date function | Excel Worksheet Functions | |||
| How can I use the "TODAY ()" Function in an "IF/THEN" calculation | Excel Worksheet Functions | |||
| =SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8) | Excel Worksheet Functions | |||
| IF(D2="Paid","",IF(C2="","",IF(TODAY()<C2,"",IF(TODAY()-C214,"Ove | Excel Discussion (Misc queries) | |||
| =IF((TODAY()-B8)30, "Overdue", "Current"), | Excel Discussion (Misc queries) | |||
Threaded Mode
