Need help determining what formula to use

New Contributor

Hi, I am just learning excel and am not sure how to do the below


I’m trying to count the number of times a "pass successful" comes up directly after a pass is thrown. Eg. For every “GA Chest Pass” how many times is this followed by  “Pass success” in the next cell along.

Does that make sense?


Thank you!

3 Replies

Hi @BEliza 


Based on my understanding from your post, you can use below Countifs() function:


=COUNTIFS($C$4:$C$13,"="&F4,$D$4:$D$13,"pass successful")


A sample file is also attached for your reference. You may also share your actual data so that more specific solution can be suggested.






Thanks for that, its almost right I think. 


The picture below of a fake data set shows that I have different pass styles that have "pass success" after it. The formula you posted counted all of the "Pass success" not just the ones after "GA Chest pass". How do I refine it to show how successful each individual pass type is separately?





Please use below modified formula:


=COUNTIFS($C$4:$C$13,"GA Chest",$D$4:$D$13,"Pass Successful")


Now it will count all "GA Checst" only if they are followed by "Pass Successful"

Hope it will help.



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies