sumproduct formula

[Todd]

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$64>0),$C$7:$C$64*D$7:D$64)


Column C Column D
5 100
0 400
2 300
4 200

= 500+600+800


Thanks,


Todd

[daddylonglegs]

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$64>0),$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)

[Todd]

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$64>0),$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
>
>