How to total cells in a range with data input

  • Thread starter Thread starter SylviBeOS
  • Start date Start date
S

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 B4:D14. 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 B4:D14 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
 
You could try:

=COUNT(B4:D14)

--

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 B4:D14. 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 B4:D14 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
 
Back
Top