| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need page number & total pages in worksheet - not header or footer | Excel Worksheet Functions | |||
| How can I use dcount to total the number of columns with entries? | Excel Worksheet Functions | |||
| How to determine total value of business for sale | Excel Worksheet Functions | |||
| TOTAL NUMBER OF ENTRIES | Excel Worksheet Functions | |||
| Index to determine total of values | Excel Worksheet Functions | |||
Hybrid Mode
