use the following formula:

=AVERAGE(range)

where

range = the range of cells you wish to take the average of (e.g. "B3:B10")

hope this helps

Brendan

"dip43" wrote:

> In excell What formula do I use to for above problem?