Zak,

Sounds like you just need a simple average of cells containing values.

Use,

=AVERAGE(A1:A10)

The function will ignore blank cells. AVERAGE adds up the values in
the list and then divides that sum by the number of non-blank cells.



Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=493444