Is 20 supposed to be 25

If so

=subtotal(1,c1:c2)

change your range to the range you are trying to average.


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=499800