=SUMPRODUCT((B2:C20)*(D2:D20<""))



"Jimish" skrev:

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