Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with SumProduct | Excel Worksheet Functions | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
sumproduct | Excel Worksheet Functions | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions |