| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Every Trird Cell In A Row
Greetings,
I have a series of rows that I sum up in the first column. I did have them staggered so that I could just use =SUM(B2:CC2) in the first row and copy it down to the other two rows. Simple. But when I tried to collect the same data after compressing the bottom 2 row into the 1st row (where there was just blank space) I realized I haven't a clue as to how that is done! Anyone have any ideas as to how to get the sum from every third cell? Any assistance on this question will be greatly appreciated. -Minitman |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM Every Trird Cell In A Row
=SUM(B2:CC2)
get the sum from every third cell? So, every 3rd cell would be B2, E2, H2, K2, etc? If you will *never* insert new columns in front of the range: =SUMPRODUCT(--(MOD(COLUMN(B2:CC2),3)=2),B2:CC2) If you might insert new columns in front of the range: =SUMPRODUCT(--(MOD(COLUMN(B2:CC2)-COLUMN(B2),3)=0),B2:CC2) -- Biff Microsoft Excel MVP "Minitman" wrote in message ... Greetings, I have a series of rows that I sum up in the first column. I did have them staggered so that I could just use =SUM(B2:CC2) in the first row and copy it down to the other two rows. Simple. But when I tried to collect the same data after compressing the bottom 2 row into the 1st row (where there was just blank space) I realized I haven't a clue as to how that is done! Anyone have any ideas as to how to get the sum from every third cell? Any assistance on this question will be greatly appreciated. -Minitman |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM Every Trird Cell In A Row
Hey Biff,
I've not used MOD before and had no idea what it did, now I know. Thanks. -Minitman On Fri, 11 Apr 2008 16:53:54 -0400, "T. Valko" wrote: =SUM(B2:CC2) get the sum from every third cell? So, every 3rd cell would be B2, E2, H2, K2, etc? If you will *never* insert new columns in front of the range: =SUMPRODUCT(--(MOD(COLUMN(B2:CC2),3)=2),B2:CC2) If you might insert new columns in front of the range: =SUMPRODUCT(--(MOD(COLUMN(B2:CC2)-COLUMN(B2),3)=0),B2:CC2) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM Every Trird Cell In A Row
You're welcome!
-- Biff Microsoft Excel MVP "Minitman" wrote in message ... Hey Biff, I've not used MOD before and had no idea what it did, now I know. Thanks. -Minitman On Fri, 11 Apr 2008 16:53:54 -0400, "T. Valko" wrote: =SUM(B2:CC2) get the sum from every third cell? So, every 3rd cell would be B2, E2, H2, K2, etc? If you will *never* insert new columns in front of the range: =SUMPRODUCT(--(MOD(COLUMN(B2:CC2),3)=2),B2:CC2) If you might insert new columns in front of the range: =SUMPRODUCT(--(MOD(COLUMN(B2:CC2)-COLUMN(B2),3)=0),B2:CC2) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
