COUNTA Help Please

[graviz]

I have a range of if statements (located D6:D18) and am trying to do a count formula that only counts if there is a value.

My current count formula

COUNTA(Monthly_Config!$D$6:$D$18)

An example of one of the "IF" statements:

=IF(M_CSAT!B2="","",RIGHT(M_CSAT!B2,LEN(M_CSAT!B2)-3))

I only have 7 cells that have a month in them however the count formula states 13. How can I adjust my formula to only count non "" cells?

 

[T. Valko]

I have a range of if statements (located D6:D18) and am trying to do a count formula that only counts if there is a value.

My current count formula

COUNTA(Monthly_Config!$D$6:$D$18)

An example of one of the "IF" statements:

=IF(M_CSAT!B2="","",RIGHT(M_CSAT!B2,LEN(M_CSAT!B2)-3))

I only have 7 cells that have a month in them however the count formula states 13. How can I adjust my formula to only count non "" cells?

Assuming the values to be counted are TEXT:

=COUNTIF(Monthly_Config!$D$6:$D$18,"?*")

 

[graviz]

It worked perfectly. Thank you!

 

[T. Valko]

It worked perfectly. Thank you!

You're welcome. Thanks for the feedback!