| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif with two criterias
How can I use sumif when I want to meet two criteria?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif with two criterias
I'm guessing you have 2 criteria in 2 different columns?
A1 = criteria1 A2 = criteria2 =SUMPRODUCT(--(B1:B10=A1),--(C1:C10=A2),D1:D10) Sums D where B = A1 and C = A2 Biff "leung" wrote in message ... How can I use sumif when I want to meet two criteria? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I have 2 criterias within sumif function | Excel Worksheet Functions | |||
| I want to use the same function as SUMIF, but for two criterias | Excel Worksheet Functions | |||
| excel, how do I get sumif with two criterias? | Excel Worksheet Functions | |||
| SUMIF with 2 criterias | Excel Worksheet Functions | |||
| Sumif or Sumproduct 2 criterias not working | Excel Discussion (Misc queries) | |||
Linear Mode
