Excel - COUNT Function Problem - Expert Solution

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

Repost 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 S. H. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 25/05/2018 - 06:14
Hi
Excelchat Expert 25/05/2018 - 06:14
Welcome to Got it Pro
Excelchat Expert 25/05/2018 - 06:16
Are you there?
User 25/05/2018 - 06:16
hello!
Excelchat Expert 25/05/2018 - 06:16
Can you please elaborate on your requirement so that i can help better
Excelchat Expert 25/05/2018 - 06:16
Also is there some sample data that you can share
User 25/05/2018 - 06:16
Am I talking to the same expert? I have discussed the project ealier ?
Excelchat Expert 25/05/2018 - 06:17
No
User 25/05/2018 - 06:17
ah I guess not
Excelchat Expert 25/05/2018 - 06:17
I am talking to you for the first time
User 25/05/2018 - 06:17
thats not going to work
Excelchat Expert 25/05/2018 - 06:17
oh
Excelchat Expert 25/05/2018 - 06:17
If you tell me may be i can help you out
User 25/05/2018 - 06:18
its a big & complicated task, so 1 hour is not enough and dealing with new advisor everytime with no result is not going to help me
User 25/05/2018 - 06:18
its like I am running in circle
Excelchat Expert 25/05/2018 - 06:18
oh
Excelchat Expert 25/05/2018 - 06:18
What should i do now?
User 25/05/2018 - 06:19
let try but what if we are not able to finish it in 1 hour time
Excelchat Expert 25/05/2018 - 06:19
Do you want me to end it so that you can connect it to same user..you can also mention in your post so that same user picks up
Excelchat Expert 25/05/2018 - 06:20
What do you say?
User 25/05/2018 - 06:20
what should I mention?
User 25/05/2018 - 06:21
he asked me to use repost with the same description below and I have done it
Excelchat Expert 25/05/2018 - 06:21
Mention that the user to whom i connected earlier should pick up. others please dont pick it
Excelchat Expert 25/05/2018 - 06:21
Repost means any one else can pcik up..it means you had bad experience with previous user
User 25/05/2018 - 06:22
ok cool
User 25/05/2018 - 06:22
please end the chat
User 25/05/2018 - 06:22
thanks
Excelchat Expert 25/05/2018 - 06:22
I will end from my end but please do give good rating so that my rating is not affected
Excelchat Expert 25/05/2018 - 06:22
Hope you understand
User 25/05/2018 - 06:22
yes sure that not your fault :)
Excelchat Expert 25/05/2018 - 06:23
Thanks
User 25/05/2018 - 06:23
welcome!
Excelchat Expert 25/05/2018 - 06:23
Have a great day
User 25/05/2018 - 06:23
same to you
Excelchat Expert 25/05/2018 - 06:23
You can end from your end now

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
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc