Jimish:

You need a fifth column to perform this computation;every cell shall need a
formula; the first cell formula should be:

=IF(D2="",B2*C2,0)

Copy the formula to all the cells in the fifth column; the total of this
column shall be your answer.




"Jimish" wrote:

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