Nov 24 2022 07:59 PM
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)
Nov 25 2022 04:36 AM
@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?
Nov 25 2022 12:03 PM
If you have access to TEXTSPLIT, it's straightforward. Presuming the data is in A1, for example:
=COUNTA(TEXTSPLIT(A1,"-"))
.