How to total cells in a range with data input

  • Thread starter Thread starter Peo Sjoblom
  • Start date Start date
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
 
Sylvie,

If I understand you correctly try =COUNT(B4:D14)

If the cells may have text as well then use COUNTA(B4:D14)

HTH

Sandy
 
Thank you for a speedy reply, problem solved. I will refrain from
cross-posting.
Sylvie
 
My pleasure Sylvie,
cross posting is OK IMHO but multiposting is not.. The big difference is
that with cross posting
the person who answer can see that it has been posted in several NGs and
he/she can also see any other answers.
Multiposting will leave no such trace and it will also confuse Google. It
doesn't matter much if there is a
question that takes 5 seconds to answer but if I spend 30 minutes to come up
with a fairly time consuming
answer it is not fun to know it has been answered in 2 other NGs. It's a
waste of resources..
 
Back
Top