| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add up the last 12 cells (containing values) in a column.
One way to find the last row and count back.
=SUM(INDIRECT("a"&MATCH(999999,A:A)-11&":a"&MATCH(9999999,A:A))) -- Don Guillett Microsoft MVP Excel SalesAid Software "Michelle D" <Michelle wrote in message ... I have a table of hours worked by temporary staff which I am constantly adding new values to. I need to calculate average hours worked from the last 12 weeks they worked at any given moment so I want a total of there hours for the last 12 weeks. I have limited knowledge of excel - so at the moment - I add the latest value - then recalculate the sum of those 12 cells - I would like a table that automatically calculates the sum of the last 12 cells in a column - whatever cells they are. Hope you can help, Michelle |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total cells of one column based on the values in another column? | New Users to Excel | |||
| Count cells w/values in column if the data in column a matches cri | Excel Worksheet Functions | |||
| How to copy values available in different cells of a column into d | Excel Discussion (Misc queries) | |||
| How do i set up a dropdown listbox of values in a column of cells | Excel Worksheet Functions | |||
| How do I re-calculalate the values for all cells in a column | Excel Worksheet Functions | |||
Threaded Mode
