=SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8)

J

JR

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
 
R

Ron Coderre

=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:B38>0)*(B8:B38<TODAY())*(D8:D38+H8:H38+L8:L38+P8:p38+U8:U38+Y8:Y38))


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
J

JR

It works, however I need a way to blank the zero

Ron Coderre said:
=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:B38>0)*(B8:B38<TODAY())*(D8:D38+H8:H38+L8:L38+P8:p38+U8:U38+Y8:Y38))


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
Click to expand...
 
Top