text count issue, it seems to count the formula also?

hi,

im having a problem with this "counta" formula, it seems to count the inside formula also. how do i go about with this issue. i want it to count only the text filled cells.

thanks in advance


Pang


customer count different.xlsx

See if this helps

=(COUNTA(B5:B1000)-COUNTBLANK(B5:B1000))




Click the star icon in the lower left part of the contributor's post and add Reputation

hey elayaz,

that formula works, i should have thought of something like that. haha

all is good.

thanks alot

pang