Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with formula please
Hello,
I want to calculate the average value of a large range of cells in a column. The snag is that many of the cells are blank, or contain text. I only want to average those which contain a number, (they are positioned irregulary & unpredicatbly down the column). Can someone help me with a formula to do it please ? Thanks K |