troubleshooting Question

Excell Sheet - How many person talk E in this category ? which formula.

Avatar of LelloLello
LelloLello asked on
Microsoft Excel
3 Comments2 Solutions392 ViewsLast Modified:
I have an attached excell sheet.

First name |  Last Name  |  Language (E, F, or B) | Track (ILA or RET or GRP or FIN)

In that excell I was able to know how many Track I have (=COUNTIF(G2:G22,"ILA")).

Now I'd like to know How many ILA talk French? or How many ILA talk english 'E' or B'. Which formula i should use ?

Please take a look and let me know.
registrations-.xlsx
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros