How do you determine a total number of worksheet entries?

  • Thread starter Thread starter The Stoat
  • Start date Start date
T

The Stoat

Hi all,

I am building a financial worksheet which will involve daily entries for
sums of money progressively going down the page. Can anyone tell me how to
determine the total number of entries there are so an average payment value
can be calculated?

Many thanks,

Matt.
 
Hi stoat,
I think =count(the range of cells to be counted) would do it. See if it helps.
 
Hi Matt,

Sounds like COUNT and COUNTA are the functions you are looking for.

Something like,
=SUM(A:A)/COUNT(A:A)

or maybe just
=AVERAGE(A:A)
AVERAGE will ignore blanks but will count zeroes.

HTH
Martin
 
Hi,

You don't need to know the number of entries to return the average. The
formula

=AVERAGE(A1:A1000)

returns the average of populated cells in that range and Excel is clever
enough to ignore blanks and text. A cell with 0 (zero) in would be included
in the calculation.

Mike
 
Back
Top