Equation question

[kevnb]

I have a column where entries are made every day. Sometimes there is a number, most times it's blank. I want a formula that counts only the last five entries made, no matter how far apart they are. For example entries were made for b1, e1, g1, h1, m1 with everything else being blank. I want to get the average for the five cells with numbers.

Thanks
Kevin

 

[PaddyD]

haven't you asked this before?

http://216.92.17.166/board/viewtopic.php?topic=12570&forum=2

 

[kevnb]

I had forgotten about that. Was working on too many different things back then. Thanks for hte reminder.

Kevin