Counting Cells with multiple criteria.One criteria supporting wild

A

Azhar Saleem

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
 
G

Guest

-----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
Click to expand...
(left(b1,1)="c",1,0),0) Then total up the column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Cells with multiple criteria.One criteria supporting wild 1
Need to Match Multiple Results and Count Text in Different Column 4
COUNTING 1
Count If 2
vlookup---using data outside the range specified in the formula 4
using vlookup to find data outside a specified range 1
"search" a different sheet with multiple criteria 2
DE-Concatenate but maintain relationship and record structure 1

Top