SUM Every Thrid Cell In A Row

[Minitman]

Greetings,

I need to get the total of every 3rd cell in a row.

Is there a formula that will skip to every 3rd cell in a row and sum
just those cells?

Any help will be appreciated.

Thanks for looking at my question.

-Minitman

 

[Gary''s Student]

=SUMPRODUCT(--(MOD(COLUMN(1:1)-COLUMN(A1),3)=0),10:10)
for row#10

 

[Minitman]

Hey Gary's Student,

Thanks for the reply.

I must admit, I do not understand what your code is doing, how it is
doing it or how to modify it to work for my application.

I looked the commands in MS Help and the did not help.

Could you explain, please?

Thanks.

-Minitman