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

=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

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

"Ron Coderre" wrote:

=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