Counting Cells with multiple criteria.One criteria supporting wild

A

Azhar Arain

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
 
M

Max

Assuming the source data is in cols A and B,

Try in say, C1:

=SUMPRODUCT((TRIM(A1:A100)="John")*(LEFT(TRIM(B1:B100),1)="C"))

Adjust the ranges to suit

Note: You can't use entire col references (A:A, B:B, etc) in SUMPRODUCT
 

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