| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if one or another criteria
I've been trying to figure this out on my own based on other similar posts
but I think I just don't understand array formulas. Anyway... I want to sum a range of cells if 1 of 2 possible criteria are met within a different range of cells. Example: RowA RowB RowC Col1 P S W Col2 4 2 1 Sumif(A1:C1,"P" OR "S", A2:C2) It's the OR that I can't figure out. Thanks a Bunch! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| =DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Threaded Mode
