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

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

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

 

[Todd]

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