How do I "count" the number of cells with a value in them? I have a
spreadsheet with 277 rows, but only some of these have data. I want to
find the "AVERAGE" of the cells with data. If I use the AVERGAE
function it uses the total number of cells (277) but some of these are
blank which skews the value. Thank in advance. So glad I found this
site. :)


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=488409