Excel - COUNT Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula written into cells (AI8 to EK8) to identify patterns and then count specific data. sheet name: SHOPEE PATTERNS ONE ROW have data of different shooter (wins and losses from cells B to H) that I need identify. There were 2 rows (AI4:EK4 and AI2:EK2) that will determine which cells to count and which to keep blank after applying the formula.
Solved by V. J. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 22/05/2018 - 07:37
Excelchat Expert 22/05/2018 - 07:37
Welcome, Thanks for choosing Got It Pro-Excel.
User 22/05/2018 - 07:38
please tell me quickly whether it can be done
Excelchat Expert 22/05/2018 - 07:38
Excelchat Expert 22/05/2018 - 07:38
Do you have sample data that we can work on?
User 22/05/2018 - 07:38
last advisor was unable to provide any help in this
User 22/05/2018 - 07:38
Excelchat Expert 22/05/2018 - 07:39
Provide it please...
User 22/05/2018 - 07:39
excel link
User 22/05/2018 - 07:39
User 22/05/2018 - 07:40
Doc file for better and clear understanding (Just read page 1)
User 22/05/2018 - 07:40
Excelchat Expert 22/05/2018 - 07:41
Excelchat Expert 22/05/2018 - 07:41
Just a moment as I go through this please.
User 22/05/2018 - 07:52
understood the woek?
User 22/05/2018 - 07:52
Excelchat Expert 22/05/2018 - 07:53
This is the first time I am encountering this; so it needs more time....
Excelchat Expert 22/05/2018 - 07:53
I am still following...
User 22/05/2018 - 07:54
User 22/05/2018 - 08:04
any progress?
Excelchat Expert 22/05/2018 - 08:05
It can be done.
Excelchat Expert 22/05/2018 - 08:06
It will need more time than the one which we are assigned.
User 22/05/2018 - 08:06
ok what should, I do then?
Excelchat Expert 22/05/2018 - 08:07
I wish I had more time so that I can give a perfect solution for you on this.
User 22/05/2018 - 08:07
I can buy the plan. can I cancelled it anytime
Excelchat Expert 22/05/2018 - 08:08
Yeah you can.
User 22/05/2018 - 08:08
ok tell me how you are planning to achieve it
User 22/05/2018 - 08:08
ok great
User 22/05/2018 - 08:10
I can see there is free trial for unlimited session for a week
User 22/05/2018 - 08:10
I am usning it if not satified I will cnacek it straight away
User 22/05/2018 - 08:11
Please give me your advisor id or something, so that we can resume this session
User 22/05/2018 - 08:12
Excelchat Expert 22/05/2018 - 08:12
I am working on the solution.
User 22/05/2018 - 08:15
ok, please provide your expert ID. if chat ends we can resum the work
User 22/05/2018 - 08:16
or else I have to start again with the new person
User 22/05/2018 - 08:25
User 22/05/2018 - 08:27
update me
User 22/05/2018 - 08:36
I guess you too unable to resolve this

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc