=sumproduct(B1:B10,C1:C10,--(D1:D10<""))

possibly.

--
Regards,
Tom Ogilvy


"Jimish" wrote in message
ups.com...
i have a file with 4 cols. say
desc weight rate a rate b

now i want to get sumproduct of col weight and rate a only if there is
any value in rate b. i got sum of col weight only of those col where
there there is value in rate b. so how to solve this problem