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
|