Forum Discussion
Solved
SUMIF function error
I have a table where Column 7 contains the "Due Date" of the value in Column 9. Some of the "Due Dates are in the future (outside the reporting date) so I created the following formula: =SUMIF((R5C...
Actually that intermediate " and & are very important. If you leave the Max_Due_Date inside the quotes excel will not evaluate it as a named range but as text and hence result in 0. Try moving it outside the quotes. See the image below showing both inside and outside the quotes:
and I forgot to mention previously, I believe your named calculation:
"a named item containing the calculated date of the first of the current month, plus the number of days in the month, minus 1"could be achieved easier using
=EOMONTH(TODAY(),0)
Also, thank you for your VERY prompt suggestion -- thank you.