| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF with criteria in 2 columns
I have the following...
CUSTOMER CODE Jones A Jones B Jones B Smith A Smith C Smith A Jones B Davis B I need to be able to count how many cells ion the CODE column contain 'B', but only if the CUSTOMER is 'Jones' I cannot sort, or use named ranges in this case... I'm sure its really straightforward, but I just can't work it out! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum items in a column based on criteria located in other columns | Excel Discussion (Misc queries) | |||
| countif = < AND value in adjacent columns match criteria | Excel Worksheet Functions | |||
| Excel COUNTIF Function - a range as criteria ? | Excel Worksheet Functions | |||
| countif criteria only one word of few doesn't work | Excel Worksheet Functions | |||
| want to count in two columns; countif (colA=x AND colB=y)? | Excel Worksheet Functions | |||
Threaded Mode
