Another simple "average of..."?

  • Thread starter Thread starter FISH
  • Start date Start date
F

FISH

(Using Excel 2002)

Is there a way to have Excel automatically enter the number of cell (with
entries in them) into another cell.

A simple example:
Let's say I have values entered into D5, D6, and D7, but D8-D14 are blank. I
have the total number of entries in D15 now as 3 (3 entries are filled in),
but I'd like that to change (to 4, as 4 entries are no filled in)
automatically when I enter a value into D8. Then when I enter another value
into D9, I'd like D15 to change to "5", and so on...

Is there a way Excel can do this?

My spreadsheet is more complex or I wouldn't need to figure this out...I
could just enter it in myself...lol.

THANKS...
 
(Oops, wrong title to this thread, sorry. I also had a question about the
averages of a range of cells, but solved that one.)
 
Thank you. One more question if you don't mind:

Is there a way to only count numerical entries? Some cells will have numbers
in them and some will have an x (for no entry for that week). Can the
formula be altered to only count numerical entries?


Thanks again !!!
 
Use COUNT Function for numerics.

BTW.....these Functions and their uses are found in Excel Help under "Count"


Gord
 
Back
Top