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

M

MyVeryOwnSelf

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
Can someone Decipher this Excell Formula for me ??? 3
Can someone decipher this excell formula for me please? 1
I need some changes in a code 5
Change data with a macro 8
how do I create a formula in excel with using 2 columns of info? 1
Macro to change information 0
Simplify the Macro of Looping 1

Top