How do you determine a total number of worksheet entries?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Stoat - 19 Jan 2008 11:47 GMT

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.

Reply to this Message

Raymond Angana - 19 Jan 2008 12:12 GMT

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

> Hi all,
>
[quoted text clipped - 6 lines]
>
> Matt.

Reply to this Message

MartinW - 19 Jan 2008 12:12 GMT

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 all,
>
[quoted text clipped - 8 lines]
>
> Matt.

Reply to this Message

Mike H - 19 Jan 2008 12:17 GMT

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

> Hi all,
>
[quoted text clipped - 6 lines]
>
> Matt.

Reply to this Message

The Stoat - 19 Jan 2008 17:46 GMT

Many thanks everyone!

> Hi all,
>
[quoted text clipped - 6 lines]
>
> Matt.

Reply to this Message