SUM Every Thrid Cell In A Row
 

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

SUM Every Thrid Cell In A Row
 

=SUMPRODUCT(--(MOD(COLUMN(1:1)-COLUMN(A1),3)=0),10:10)
for row#10
--
Gary''s Student - gsnu2007j


"Minitman" wrote:

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

SUM Every Thrid Cell In A Row
 

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

On Tue, 10 Jun 2008 09:49:04 -0700, Gary''s Student
wrote:

=SUMPRODUCT(--(MOD(COLUMN(1:1)-COLUMN(A1),3)=0),10:10)
for row#10
--
Gary''s Student - gsnu2007j


"Minitman" wrote:

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