Counta function question
How about =COUNT(range)-COUNTBLANK(range) This subtracts the count of blanks
from the total count in the range, which, by implication, gives you the
number of non-blank entries.
Dave
--
Brevity is the soul of wit.
"Karen McKenzie" wrote:
I have an extract of data that shows detail by item, then an overall result.
I want to use the counta function to count the number of non blank entries
between each entry called result ie:
Equipment Amount Count
21053 192.35
21064 207.30
Result 2
60987 303.20
12156 97.20
30752 1426.67
Result 3
Can this be done?
|