=SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8)
=SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8)
SUMIF accepts one test range, one criteria, and one summary range
See if this works for you:
=SUMPRODUCT((B8:B380)*(B8:B38<TODAY())*(D8:D38+H8 :H38+L8:L38+P8:P38+U8:U38+Y8:Y38))
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"JR" wrote:
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
|