| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
=SUMPRODUCT(--(($B$2:$B$6="X")+($C$2:$C$6="Y")0))
MeatLightning wrote: I have thre columns: One holds names (record keys), another could hold "X", the last can have a "Y". I want to know how many records have either an "X" or a "Y" value? For example: Column A Column B Column C Matt X Bill Y John X Y Fred X Y Tom How many records (i.e. column A) have either an X or Y? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count on multiple columns | Excel Worksheet Functions | |||
| Count with multiple conditions | Excel Worksheet Functions | |||
| count cells over multiple sheets | Excel Worksheet Functions | |||
| Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
