sumproduct and if

  • Thread starter Thread starter Jimish
  • Start date Start date
J

Jimish

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reconstructing a table with Arrays 1
Complicated sum 12
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Help with mess of code 1
Loop Through Text and Test for Scenarios Q 31
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
sumproduct help 9
sum visible amounts 2

Back
Top