Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 293
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine First and Last Name colums to create thrid column of full Mark M Excel Worksheet Functions 3 November 19th 07 01:29 AM
How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell [email protected] Excel Worksheet Functions 2 November 7th 07 09:39 AM
How to create/run "cell A equals Cell B put Cell C info in Cell D abmb161 Excel Discussion (Misc queries) 5 January 26th 06 06:36 PM
Display thrid letter formula koba Excel Discussion (Misc queries) 4 November 30th 05 05:19 AM
Cell Formula reference to cell Based On third Cell Content Gabriel Excel Discussion (Misc queries) 1 February 11th 05 06:36 AM


All times are GMT +1. The time now is 06:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"