Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Last 12 Columns
Hi All, I have a spreadsheet that has historical data but I just want the
most recent 12 month average (months are across the top, metric names are in Column A)... So Units Sold is in A2, and B1 has Jan 2000 C1 Feb 2000 and so on. In B2, C2, D2 and so on sales data for the respective month is added. I have another sheet that has the 3 most recent months in 3 columns then another column that has a benchmark as a 12 month average of the most recent 12 months. My question is, how can I automate the average so it will grab the most recent 12 months...? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the average of entries in a group of columns? | Excel Discussion (Misc queries) | |||
Average the total of 3 columns | Excel Discussion (Misc queries) | |||
Average/Sumif based on several columns | Excel Worksheet Functions | |||
Average/Sumif based on several columns | Excel Worksheet Functions | |||
How do I get an average sale if multiple columns? | Excel Worksheet Functions |