How to total cells in a range with data input

[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

 

[RagDyer]

You could try:

=COUNT(B414)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

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