| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Counting Cells with multiple criteria.One criteria supporting wild
How can I count cells starting with character "C" in second column and
related with the name John only. John Car Steve Bus Bush Cycle Powell Truck Bruce Van Bush Car Powell Bus Powell Cycle Bruce Truck John Van Steve Car Steve Bus Bush Cycle Powell Truck John Van John Cycle John Car |
|
#2
|
|||
|
|||
|
-----Original Message----- How can I count cells starting with character "C" in second column and related with the name John only. John Car Steve Bus Bush Cycle Powell Truck Bruce Van Bush Car Powell Bus Powell Cycle Bruce Truck John Van Steve Car Steve Bus Bush Cycle Powell Truck John Van John Cycle John Car . Create a third column. Insert the formula if(a1="john",if (left(b1,1)="c",1,0),0) Then total up the column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| counting with a criteria in multiple transactions | Excel Worksheet Functions | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Hybrid Mode
