Same row different Answer.
 

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,"",SU M((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.

Hi,

Try

=IF(SUM((IF(MOD(COLUMN(C6:AA6),3)=0,C6:AA6)))=0,"" ,SUM((IF(MOD(COLUMN(C6:AA6),3)=0,C6:AA6))))

with Ctrl+shift+enter.

If not, let me know more detail about what you are trying to do.

Govind.


Steved wrote:

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,"",SU M((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.

Thankyou Govind, I put in COL and it did not work, I should have known better,
Thanks to you another lesson learnt.

Cheers.


"Govind" wrote:

Hi,

Try

=IF(SUM((IF(MOD(COLUMN(C6:AA6),3)=0,C6:AA6)))=0,"" ,SUM((IF(MOD(COLUMN(C6:AA6),3)=0,C6:AA6))))

with Ctrl+shift+enter.

If not, let me know more detail about what you are trying to do.

Govind.


Steved wrote:

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,"",SU M((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.