calculate average of populated cells

L

learmont

i got it...

=SUM(B5:B56)/COUNTA(B5:B56)

would sum values in all rows from 5 to 56, and divide it by count
which returns all rows with data...

thanks, be
 
R

RagDyer

Just so you realize, CountA() will count *more* then just numbers.
Are you sure that you want to divide your sum total by numbers & letters
(text) & nulls & spaces?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


i got it...

=SUM(B5:B56)/COUNTA(B5:B56)

would sum values in all rows from 5 to 56, and divide it by counta
which returns all rows with data...

thanks, bey
 
Top