ExcelBanter - How do I create a YTD table which compares production for 4 facil.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I create a YTD table which compares production for 4 facil. (https://www.excelbanter.com/excel-discussion-misc-queries/133538-how-do-i-create-ytd-table-compares-production-4-facil.html)

How do I create a YTD table which compares production for 4 facil.

Maybe something like the csv file below would be useful.

---------------- cut here -------------
,A,B,C,D,A YTD,B YTD,C YTD,D YTD
Jan,,,,,=B2,=C2,=D2,=E2
Feb,,,,,=F2+B3,=G2+C3,=H2+D3,=I2+E3
Mar,,,,,=F3+B4,=G3+C4,=H3+D4,=I3+E4
Apr,,,,,=F4+B5,=G4+C5,=H4+D5,=I4+E5
May,,,,,=F5+B6,=G5+C6,=H5+D6,=I5+E6
Jun,,,,,=F6+B7,=G6+C7,=H6+D7,=I6+E7
Jul,,,,,=F7+B8,=G7+C8,=H7+D8,=I7+E8
Aug,,,,,=F8+B9,=G8+C9,=H8+D9,=I8+E9
Sep,,,,,=F9+B10,=G9+C10,=H9+D10,=I9+E10
Oct,,,,,=F10+B11,=G10+C11,=H10+D11,=I10+E11
Nov,,,,,=F11+B12,=G11+C12,=H11+D12,=I11+E12
Dec,,,,,=F12+B13,=G12+C13,=H12+D13,=I12+E13