Hi,

Please find herein another solution. Assuming your range of data is in
A1:A30 (1 to 30). In cell A32, enter the following array formula
(Ctrl+Shift+Enter).

=SUM(IF(MOD(ROW(A1:A30),14)=0,A1:A30))

Hope this helps.

Regards,

Ashish Mathur

"malik641" wrote:


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