software

I am trying to get a formula that
1. if a cell in column c is greater than zero will multiply that cell by
another and total the result by column.

What I have is (which is not working)

=SUMPRODUCT(--($C$7:$C$64gt;0),$C$7:$C$64*D$7$64)Column C Column D
5 100
0 400
2 300
4 200

= 500 600 800Thanks,Todd


Hi Todd

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

This slight modification might help

=SUMPRODUCT(--($C$7:$C$64gt;0),$C$7:$C$64,D$7$64)

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

=SUMPRODUCT($C$7:$C$64,D$7$64)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=520863I was wrong! it wasn't that formula but the formula being used to check it
with. Thank you for the help.

quot;daddylonglegsquot; wrote:

gt;
gt; Hi Todd
gt;
gt; Your formula should work if you just have numbers or blanks in C764,
gt; what result do you get? Why doesn't it work?
gt;
gt; This slight modification might help
gt;
gt; =SUMPRODUCT(--($C$7:$C$64gt;0),$C$7:$C$64,D$7$64)
gt;
gt; although if you never have negative values in column C you could just
gt; use
gt;
gt; =SUMPRODUCT($C$7:$C$64,D$7$64)
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=520863
gt;
gt;