| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF question
I wanted to conitionally SUM All Ds For which the correspoding C cell is
1.* or 2.* or 3.* I tried something like following. which did not work =SUMIF(C1:C100, "=AND(C11,C1 <2)", D1:D100) C D 1.1 5 1.2 4 1.3 3 2.1 1 2.2 1 2.3 1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF question
=SUMPRODUCT(--(C1:C1001),--(C1:C100<2),D1:D100)
"Shan" wrote: I wanted to conitionally SUM All Ds For which the correspoding C cell is 1.* or 2.* or 3.* I tried something like following. which did not work =SUMIF(C1:C100, "=AND(C11,C1 <2)", D1:D100) C D 1.1 5 1.2 4 1.3 3 2.1 1 2.2 1 2.3 1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF | Excel Worksheet Functions | |||
| SUMIF Question Criteria | Excel Worksheet Functions | |||
| Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
| sumif Question | Excel Discussion (Misc queries) | |||
Linear Mode
