Forum Discussion
Using Ctrl+F vs Conditional Formatting
Somewhat of an odd question here... I have a list of values in an Excel Sheet that contain values like "Successful", "Running", 'Blocked", etc. with "Successful" being the predominant values in t...
I wonder if the COUNTIFS function will help you out here. Such as
Supposing column C has your status, column B has your month number
=COUNTIFS(C3,"Successful",B3,">"&3,B3,"<"&7)
This formula would count 1 for each "Successful"s in the 2nd quarter.