Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

I need a formula to count the number of rows that contain at least one of two possible phrases, but not give me the total number of instances that both phrases occur overall.
Solved by E. B. in 33 mins
I need to display the total occurence count of different text variables in a table
Solved by G. H. in 20 mins
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
Repost: the user to whom I connected earlier should pick up. others please don't pick it 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 O. C. in 52 mins
i have a list of text and i want to categorize them and count them
Solved by B. Q. in 19 mins
I have two lists of employers followed by 4 numbers. I then have another list with the same thing. The problem is that one has employers that the other doesn't so it doesn't line up to just sum each across. Is there a way I can find the sums without having to manually count?
Solved by A. A. in 20 mins
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. H. in 60 mins
need a formula for incremental and decremented to justify the overall incident count
Solved by I. C. in 60 mins
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
Hi I've Col D ( Tech/Non-Tech) & Col J ( contains month name ). Now I want to see the total count of Technical or Non-Technical against the particular month. Can you pls assist with that?
Solved by V. F. in 12 mins
1 2 3 4