"JTee" wrote:

When using the =countif function in my spreadsheet, the formula keeps adding
the blank spaces that are in my worksheet and I don't want the blank counted.
How do I solve this?

I'm not sure of your criterion (second COUNTIF argument), so let's assume
you want to count the number of entries in A1:A20 which are not "RON", but
excluding blank or null string cell values in the count. Then you can use:

= COUNTIF(A1:A20,"<RON") - COUNTIF(A1:A20,"")

or the versatile SUMPRODUCT:

= SUMPRODUCT( (A1:A20<"RON") * (A1:A20 <""))