Need help counting specific character for specific rows
Hi Team,
I have a question that might be basic but has me stumped.
I have included an example below of what I want to do. Basically I want to count the number of time "C" appears but only for Team "Tango". Anyone in the spreadsheet can be added to team Tango so I need the formula to find anyone one in team Tango and only count "C" in their rows.
Here is an example:
Excel.jpg
Team Tango # of C: ????
Any help is really appreciated.
Last edited by ozoszil; 07-03-2022 at 05:29 PM.
Welcome to the Forum ozoszil!
Please attach your actual Excel file instead of a picture. See yellow banner at the top of the page.
Hello!
Where:
Please Login or Register to view this content.
C2:I11 = Cells with A, B, C, ...
B2:B11 = Teams
If won't work, after using the formula, before hitting enter, press and hold CTRL + SHIFT, then ENTER
If I have solved your question, please mark the thread as [SOLVED],
And consider adding reputation
?Simplicity is the ultimate sophistication? (Leonardo Da Vinci)
Regards,
F?bio Gatti
https://www.youtube.com/pulodogatti
https://www.linkedin.com/in/fabiocgatti/
https://instagram.com/pulodogatti
Cell B14 formula
Formula:
Please Login or Register to view this content.
other option
Formula:Please Login or Register to view this content.
Thank you so much Wk9128 and Gatti, both these methods worked
@ozoszil You're Welcome. Glad to help . Thank You for the feedback.
If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- Please click on the *Add Reputation button at the bottom left. Whoever helps you, give it to whoever you like
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks