If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cumulative Average on a worksheet
Can someone give me direction on what I need to do? We recently began
keeping attendance during church worship services at our church and I have created a worksheet that we can input the info in and it will total it at the bottom of the sheet. I have allowed for about 40 weeks of input but we are only on week four. What I would like to do is have a formula under the cell for total that would let me see what our average number is in the worship services on a weekly basis. |
#2
|
|||
|
|||
Cumulative Average on a worksheet
As long as the cells for future weeks are blank, you can just use the
AVERAGE( ) function. If your attendances are to be held in the cells A1 to A40 and you have the formula =SUM(A1:A40) in A41, then put this in A42: =AVERAGE(A1:A40) It will automatically adjust as you enter new attendances each week. Hope this helps. Pete |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I reference data from one worksheet to another using combob | caricc | New Users | 0 | December 17th, 2005 09:58 PM |
One worksheet to calulate different items simultaneously | John | Worksheet Functions | 4 | November 28th, 2005 07:07 PM |
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Alan Bartley | General Discussion | 1 | April 11th, 2005 05:21 AM |
list 15 worksheets data on worksheet 16 then find high 9 average | lpjr | General Discussion | 1 | March 28th, 2005 05:10 AM |
auto insert copy of worksheet | Bernie Deitrick | Worksheet Functions | 0 | March 4th, 2004 02:18 PM |