Anbuselvam K
Member
Dear Excel Genius
I have two formulas in cells C3 and D3 and I want to drag the formulas across right up to cell CX.
C3 Formula =C5SUM(Cost_Calcu[[#All],[Cost of RM01]])
D3 Formula =D5SUM(Consumption[[#All],[Consumption RM01]])
C3 formula needs to drag alternate cells of E3, G3, I3......CW3.
D3 Formula needs to drag alternate cells of F3, H3, J3......CX3.
Attached is the sample sheet for your reference.
I have two formulas in cells C3 and D3 and I want to drag the formulas across right up to cell CX.
C3 Formula =C5SUM(Cost_Calcu[[#All],[Cost of RM01]])
D3 Formula =D5SUM(Consumption[[#All],[Consumption RM01]])
C3 formula needs to drag alternate cells of E3, G3, I3......CW3.
D3 Formula needs to drag alternate cells of F3, H3, J3......CX3.
Attached is the sample sheet for your reference.
Attachments

111.9 KB Views: 2