What am I missing here?

A1 = 0
B1 = 10

A1*B1 = 0

Does not effect the final sum.

Biff

"Max" wrote in message
...
In cell C1, I want the sum of (A1:A10 multiplied by B1:B10)
for each value in A1:A10 greater than zero.

Maybe in C1: =SUMPRODUCT(--(A1:A100),(A1:A10)*(B1:B10))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--