| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
