Conversation Specific SUM formula in Excel
https://techcommunity.microsoft.com/t5/excel/specific-sum-formula/m-p/633255#M31459
<P>Hello all,</P><P> </P><P>I am working with a table consisting of three columns. One column has months, the other has revenues and in the 3rd column I need the sum of the last 12 months of revenue. This means that the SUM column will have its first entry on the 12th row, when 12 months of revenue is available. So for example for rows Jan- Dec 2010 There will be one entry in the SUM column, and on the next row the column will now display the summed revenues for Feb 2010- Jan 2011. I need this to keep updating in time as entries are made.</P><P> </P><P>I thought this would be as simple as dragging down the first cell with this formula, but excel recognizes the sum formula itself as an error (for not including all nearby cells). I'm sure there is an easy solution but I am struggling to find it. Any ideas? Thanks!</P><P> </P><P> </P>Wed, 22 May 2019 13:21:02 GMTdzhogov2019-05-22T13:21:02ZSpecific SUM formula
https://techcommunity.microsoft.com/t5/excel/specific-sum-formula/m-p/633255#M31459
<P>Hello all,</P><P> </P><P>I am working with a table consisting of three columns. One column has months, the other has revenues and in the 3rd column I need the sum of the last 12 months of revenue. This means that the SUM column will have its first entry on the 12th row, when 12 months of revenue is available. So for example for rows Jan- Dec 2010 There will be one entry in the SUM column, and on the next row the column will now display the summed revenues for Feb 2010- Jan 2011. I need this to keep updating in time as entries are made.</P><P> </P><P>I thought this would be as simple as dragging down the first cell with this formula, but excel recognizes the sum formula itself as an error (for not including all nearby cells). I'm sure there is an easy solution but I am struggling to find it. Any ideas? Thanks!</P><P> </P><P> </P>Wed, 22 May 2019 13:21:02 GMThttps://techcommunity.microsoft.com/t5/excel/specific-sum-formula/m-p/633255#M31459dzhogov2019-05-22T13:21:02ZRe: Specific SUM formula
https://techcommunity.microsoft.com/t5/excel/specific-sum-formula/m-p/633334#M31462
<P><LI-USER uid="313240"></LI-USER> , for the model like this</P>
<P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 353px;"><img src="https://gxcuf89792.i.lithium.com/t5/image/serverpage/image-id/115662i3FDD9FB6974426BE/image-size/large?v=1.0&px=999" title="image.png" alt="image.png" /></span></P>
<P>you may use</P>
<PRE>=SUM(INDEX(B:B,ROW()-MIN(12,ROW()-ROW($A$1)+1)+1):INDEX(B:B,ROW()))</PRE>
<P>in C2 and drag it down.</P>
<P> </P>Wed, 22 May 2019 13:42:41 GMThttps://techcommunity.microsoft.com/t5/excel/specific-sum-formula/m-p/633334#M31462Sergei Baklan2019-05-22T13:42:41ZRe: Specific SUM formula
https://techcommunity.microsoft.com/t5/excel/specific-sum-formula/m-p/633379#M31463
<P><LI-USER uid="521"></LI-USER> </P><P> </P><P>Thank you for your quick and effective reply.</P>Wed, 22 May 2019 13:54:53 GMThttps://techcommunity.microsoft.com/t5/excel/specific-sum-formula/m-p/633379#M31463dzhogov2019-05-22T13:54:53ZRe: Specific SUM formula
https://techcommunity.microsoft.com/t5/excel/specific-sum-formula/m-p/633427#M31466
<P><LI-USER uid="313240"></LI-USER> , you are welcome</P>Wed, 22 May 2019 14:02:50 GMThttps://techcommunity.microsoft.com/t5/excel/specific-sum-formula/m-p/633427#M31466Sergei Baklan2019-05-22T14:02:50Z