
This is an example of a formula I would like to house in the AD4 cell that will count only the cells that contain the following number/”C” combination such as:
0-9C
10-99C
100-999C
I would like the formula to exclude the “CO” code along with values that do not have a "C" on the end.