How do you determine a total number of worksheet entries?
 

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.

How do you determine a total number of worksheet entries?
 

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

"The Stoat" wrote:

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.

How do you determine a total number of worksheet entries?
 

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


"The Stoat" wrote in message
...
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.

How do you determine a total number of worksheet entries?
 

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

"The Stoat" wrote:

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.

How do you determine a total number of worksheet entries?
 

Many thanks everyone!

"The Stoat" wrote:

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.