Hi Guys,

I'm new to this forum (and using excel formulas) and I'm hoping you can help me with this problem. I use excel 2000 professional so I have had trouble finding formulas that will work with this version of excel. I need to display the average of he next six values in column A in the cells in column B ignoring any blank cells (cells may be blank but have hidden formulas in them). I have attached a file, which may explain this more succinctly.
Thanks In advance for any help.


Excel Problem.jpg