Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif ...
One Way
=SUMPRODUCT((A1:A6)*(ISBLANK(B1:B6)=FALSE)) Only works if nothing is in the column B it theres text in B, the value in A will be added Dan E "fl" wrote in message ... I have two columns of data, Column A and Column B.. I need to sum Column A if there is a correspondence value in Column B. Column A Column B ----------- ---------- 2 1000 1 3000 5 2 6000 1 7 8000 . . . . . . My formular should add values in Column A: 2 + 1 + 2 + 7 = 12. The value of 5 and 1 will not be added because there is no value in Column B correspondently. I know how to do it in Access. I am not familiar with Excel. Please help. Thank you very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumIF | Excel Worksheet Functions | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |