How to total cells in a range with data input

P

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(B4:D14)

for numbers

=COUNTA(B4:D14)

for text and numbers
 
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
 
J

JE McGimpsey

To count only numeric input:

=COUNT(B4:D14)

To count all input:

=COUNTA(B4:D14)
 
Top