How to total cells in a range with data input

[Peo Sjoblom]

Please refrain from multiposting, it's better to cross post one question for
multiple groups
than to post multiple same questions to multiple groups

=COUNT(B414)

for numbers

=COUNTA(B414)

for text and numbers

 

[SylviBeOS]

Greetings to all members

I am running Excel 97.

An office colleague presented me with an issue that might be of interest to
any Excel whiz and seasoned programmers. I would certainly appreciate any
pointers in solving it. So here goes.

The set of values includes 33 cells ranging from B414. The data type is
numeric. Data is only input in a few cells.

QUESTION

What would be the function to enter in, say, cell A15 to indicate the total
number of cells in range B414 that have received data input? Or does it
involve some behind the scene VBA programming?

EXAMPLE

B6 = 9 C9 = 4 D11 = 0
Consequently, cell A15 should total 3, as only 3 cells have received data
input. I hope I am making myself clear. If not, please state so.

Thanks a million for any assistance.

Sylvie in Montreal

 

[JE McGimpsey]

To count only numeric input:

=COUNT(B414)

To count all input:

=COUNTA(B414)