G
Guest
Hello from Steved
=C6+F6+I6+L6+O6+R6+U6+X6+AA6 the sum = 22645 which is correct.
=IF(SUM((IF(MOD(ROW(C6:AA6),3)=0,C6:AA6)))=0,"",SUM((IF(MOD(ROW(C6:AA6),3)=0,C6:AA6)))) = 25484 which is wrong.
Please what is required for the above to make it correct.
Thankyou.
=C6+F6+I6+L6+O6+R6+U6+X6+AA6 the sum = 22645 which is correct.
=IF(SUM((IF(MOD(ROW(C6:AA6),3)=0,C6:AA6)))=0,"",SUM((IF(MOD(ROW(C6:AA6),3)=0,C6:AA6)))) = 25484 which is wrong.
Please what is required for the above to make it correct.
Thankyou.