sumproduct and if
 

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

sumproduct and if
 

=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

sumproduct and if
 

=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

sumproduct and if
 

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