G
Guest
I have this whole spreadsheet which i had to subtracted sum of YEAR 2 figures
from sum of YEAR 1 in the corresponding period.
For example:
Pdt 1 Result = (Year 2 M3+M2)-(Year 1 M3+M2)
Pdt 2 Result = (Year 2 M3)-(Year 1 M3)
YEAR 2 YEAR 1
M3 M2 M1 M3 M2 M1
PDT 1 200 200 400 400 400
PDT 2 400 500 500 500
PDT 3 100 100 100 200
PDT 4 500 500 200 200 200
PDT 5 100 100 100 100
Is there anyway i can do this effectively?
from sum of YEAR 1 in the corresponding period.
For example:
Pdt 1 Result = (Year 2 M3+M2)-(Year 1 M3+M2)
Pdt 2 Result = (Year 2 M3)-(Year 1 M3)
YEAR 2 YEAR 1
M3 M2 M1 M3 M2 M1
PDT 1 200 200 400 400 400
PDT 2 400 500 500 500
PDT 3 100 100 100 200
PDT 4 500 500 200 200 200
PDT 5 100 100 100 100
Is there anyway i can do this effectively?
2, PDT2 is in F2:H2. Then, in J2 you can put