Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combine First and Last Name colums to create thrid column of full | Excel Worksheet Functions | |||
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 | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Display thrid letter formula | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |