Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with an Excel formula?
I have a column of monthly figures to which I add the latest month's result
at the bottom. In the next column, I have a formula which, each month, calculates the average monthly figure for the last 12 months. I would like to change this to a weighted average - with 12 being the weighting for last month, 11 for the previous month and so on. Clearly I could create a formula to do this but is there an Excel function which already does this please? TIA V |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with an Excel formula?
Victor,
I think this will work. I put a bunch of numbers in column A beginning in row 2. In B13 I put the following formula: =SUMPRODUCT(A2:A13,ROW(A2:A13)-ROW(A13)+12) I think this does what you want, although you may have been looking for merely a built in function -- I don't think there is one. "Victor Delta" wrote: I have a column of monthly figures to which I add the latest month's result at the bottom. In the next column, I have a formula which, each month, calculates the average monthly figure for the last 12 months. I would like to change this to a weighted average - with 12 being the weighting for last month, 11 for the previous month and so on. Clearly I could create a formula to do this but is there an Excel function which already does this please? TIA V |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with an Excel formula?
"Art" wrote in message
... Victor, I think this will work. I put a bunch of numbers in column A beginning in row 2. In B13 I put the following formula: =SUMPRODUCT(A2:A13,ROW(A2:A13)-ROW(A13)+12) I think this does what you want, although you may have been looking for merely a built in function -- I don't think there is one. Art Many thanks, V |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with an Excel formula?
"Victor Delta" wrote in message
... "Art" wrote in message ... Victor, I think this will work. I put a bunch of numbers in column A beginning in row 2. In B13 I put the following formula: =SUMPRODUCT(A2:A13,ROW(A2:A13)-ROW(A13)+12) I think this does what you want, although you may have been looking for merely a built in function -- I don't think there is one. Art Many thanks, V Well. Art, it almost worked! However, I think your formula actually needs to be divided by 78 (the sum of the digits 1 to 12) to give the right answer. Thanks again, V |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) |