Another simple "average of..."?

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...
 
F

FISH

(Oops, wrong title to this thread, sorry. I also had a question about the
averages of a range of cells, but solved that one.)
 
F

FISH

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 !!!
 
G

Gord Dibben

Use COUNT Function for numerics.

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


Gord
 
Top