Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUM every other 14th cell
Is there a worksheet function that sums a given range, but every other 14th cell? Example: A1=4 A15=2 A29=4 Answer would obviously be: 10 I want the function to only add every other 14th cell. I assume it would be something like this: =SUM(range,step) or something like that I have a LOT of values to add (example:A1:A1500) and it would be a LOOOOONG line of code to add to type them all in manually. And if i wanted to add maybe 20 more of these cells (280 total cells) it would be MUCH easier to change the range in the function instead of manually entering in each specific cell. *There is no specific criteria either, just numbers. So any ideas would be great. Thanks! -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=387585 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |