I was wrong! it wasn't that formula but the formula being used to check it
with. Thank you for the help.

"daddylonglegs" wrote:


Hi Todd

Your formula should work if you just have numbers or blanks in C7:D64,
what result do you get? Why doesn't it work?

This slight modification might help

=SUMPRODUCT(--($C$7:$C$640),$C$7:$C$64,D$7:D$64)

although if you never have negative values in column C you could just
use

=SUMPRODUCT($C$7:$C$64,D$7:D$64)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=520863