=SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8)
Excel Yoda's,
Thanks for the help.
The following does not work:
=SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8)
however when using as the following it works fine:
=SUMIF(B8:B38,"<"&TODAY(),D8:Y8)
What wrong I do?
Thanks
|