How do you determine a total number of worksheet entries?

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.
 
R

Raymond Angana

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

MartinW

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
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determining the text mode from a variety of data types 17
Adding values in first "X" number of rows dynamically 3
Linking Totals Across Multiple Worksheets 3
How do I count instances of a reference? 1
How to sum by month 8
data in drop down list is limiting number of entries 0
Sum of different value in different worksheet & cell number 2
Avoiding cells being included in a chart 4

Top