| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Countif( 2 criteria = true ?)
Hi can you please help me...
I am trying count the number of items based on 2 criteria can you please help me..? Basically I have a sheet and in col A I have Code and col B I have name. eg: Col A - Col B 1001 - Mike 1001 - Dave 1001 - Keith 1002 - Terry 1001 - Mike What I am trynig to do is count how many say ("Mike" col B) with code of say ("1001" col A). so the answer according to the above will be "2". I know I can use the dsum function to do this but the problem is I am trying to get a formula in 1 cell to do the job as opposed to 2 rows + 3 columns.. hense is there a kind of countif(and) function or something I can use ??? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif criteria only one word of few doesn't work | Excel Worksheet Functions | |||
| Countif w/ Multiple Criteria | Excel Worksheet Functions | |||
| countif variable criteria | Excel Discussion (Misc queries) | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
| counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
Threaded Mode
