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
--