Counting items based on criteria located in two columns

You can simplify the formula you have in E2 by using wildcards, like this:

=COUNTIFS(A:A,"ENROLLED*")

where the asterisk is the wildcard character meaning "any number of other characters (including none)".

Strictly speaking, you don't need to use COUNTIFS in that particular case, but it makes it easy to incorporate other conditions, like this:

=COUNTIFS(A:A,"ENROLLED*",C:C,"Paid")

Hope this helps.

Pete

Dear @Pete_UK thank you very much for your valuable information, it turned out to be quite useful. A big hug!

Glad to have helped - thanks for the rep.

Pete