how to count after max digits?

New Contributor

i have excel that counting water indicator, what is the formulas to make 001-999 is counted 2 not -998?

(assume max digits is three)

2 Replies

@johnCharves Excel has built-in functions that can count the number of cells that contain numbers, count the count the number of cells that contain non-blank values, and perform some other activities that involve counts of data. But Excel has no connections to the physical world, so "counting water indicator" has no meaning to us.

What is your data that needs to be counted? What data structure/type and columns/rows is it in?

@johnCharves 

If you have access to TEXTSPLIT, it's straightforward.  Presuming the data is in A1, for example:

 

=COUNTA(TEXTSPLIT(A1,"-"))