| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
How can I sum every third cell in a row in Excel
"Ken" wrote in message
... Thank you for the reply. I cut and pasted you suggestion into my sheet and modified the array range to fit my requirements (S14:GV14). however, the result was a value# error. I will see if I can trace the error. ken If you have a Row range such as A10:A45: =SUMPRODUCT(--(NOT(MOD(ROW(Range),3))),(Range)) If you have a Column range such as A10:K10: =SUMPRODUCT(--(NOT(MOD(COLUMN(Range),3))),(Range)) Bruno |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell on one page equals cell on another page in excel? | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
| Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Threaded Mode
