M Muheet Khan Sep 7, 2003 #1 Hi, I want to add 2 columns value (verticaly) in 1 column example 2 4 2 2 4 2 2 4 2 Thanks
J JohnI in Brisbane Sep 7, 2003 #2 Muheet, If your data starts in A2 then put the folloing formula in B2, =IF(MOD(ROW(),2)=0,$A2+$A3,"") & drag down as far as you need. It gives the total of two rows, in every second row. regards, JohnI
Muheet, If your data starts in A2 then put the folloing formula in B2, =IF(MOD(ROW(),2)=0,$A2+$A3,"") & drag down as far as you need. It gives the total of two rows, in every second row. regards, JohnI
