+ Reply to Thread
Results 1 to 70 of 70

SUM every other 14th cell

  1. 07-15-2005, 02:05 PM #1
    malik641
    malik641 is offline
    Forum Contributor
    Join Date
    06-10-2005
    Location
    Central Jersey
    Posts
    117

    Arrow 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!
    Reply With QuoteRegister To Reply
  2. 07-15-2005, 02:30 PM #2
    Domenic
    Domenic is offline
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474
    Try...

    =SUMPRODUCT(--(MOD(ROW(A1:A1500)-ROW(A1),14)=0),A1:A1500)

    Hope this helps!

    Quote Originally Posted by malik641
    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!
    Reply With QuoteRegister To Reply
  3. 07-15-2005, 03:05 PM #3
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  4. 07-15-2005, 03:05 PM #4
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  5. 07-15-2005, 08:29 PM #5
    malik641
    malik641 is offline
    Forum Contributor
    Join Date
    06-10-2005
    Location
    Central Jersey
    Posts
    117
    Thanks everyone!!! They all work great

    I have another question (REALLY simple)...I never understood why there are the double dashes (or two minus signs, whatever you want to call it) before certain functions (in this case, before the MOD function).
    Why is that????
    Reply With QuoteRegister To Reply
  6. 07-15-2005, 10:05 PM #6
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  7. 07-16-2005, 12:35 AM #7
    malik641
    malik641 is offline
    Forum Contributor
    Join Date
    06-10-2005
    Location
    Central Jersey
    Posts
    117
    Good stuff. Thanks RD!
    Reply With QuoteRegister To Reply
  8. 07-16-2005, 01:05 PM #8
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  9. 07-17-2005, 01:05 AM #9
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  10. 09-05-2005, 10:05 PM #10
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  11. 09-05-2005, 10:05 PM #11
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  12. 09-05-2005, 10:05 PM #12
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  13. 09-05-2005, 10:05 PM #13
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  14. 09-05-2005, 10:05 PM #14
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  15. 09-05-2005, 11:05 PM #15
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  16. 09-05-2005, 11:05 PM #16
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  17. 09-05-2005, 11:05 PM #17
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  18. 09-05-2005, 11:05 PM #18
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  19. 09-05-2005, 11:05 PM #19
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  20. 09-06-2005, 12:05 AM #20
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  21. 09-06-2005, 12:05 AM #21
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  22. 09-06-2005, 12:05 AM #22
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  23. 09-06-2005, 12:05 AM #23
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  24. 09-06-2005, 12:05 AM #24
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  25. 09-06-2005, 01:05 AM #25
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  26. 09-06-2005, 01:05 AM #26
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  27. 09-06-2005, 01:05 AM #27
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  28. 09-06-2005, 01:05 AM #28
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  29. 09-06-2005, 01:05 AM #29
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  30. 09-06-2005, 02:05 AM #30
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  31. 09-06-2005, 02:05 AM #31
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  32. 09-06-2005, 02:05 AM #32
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  33. 09-06-2005, 02:05 AM #33
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  34. 09-06-2005, 02:05 AM #34
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  35. 09-06-2005, 03:05 AM #35
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  36. 09-06-2005, 03:05 AM #36
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  37. 09-06-2005, 03:05 AM #37
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  38. 09-06-2005, 03:05 AM #38
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  39. 09-06-2005, 03:05 AM #39
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  40. 09-06-2005, 04:05 AM #40
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  41. 09-06-2005, 04:05 AM #41
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  42. 09-06-2005, 04:05 AM #42
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  43. 09-06-2005, 04:05 AM #43
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  44. 09-06-2005, 04:05 AM #44
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  45. 09-06-2005, 06:05 AM #45
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  46. 09-06-2005, 06:05 AM #46
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  47. 09-06-2005, 06:05 AM #47
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  48. 09-06-2005, 06:05 AM #48
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  49. 09-06-2005, 06:05 AM #49
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  50. 09-06-2005, 07:05 AM #50
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  51. 09-06-2005, 07:05 AM #51
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  52. 09-06-2005, 07:05 AM #52
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  53. 09-06-2005, 07:05 AM #53
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  54. 09-06-2005, 07:05 AM #54
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  55. 09-06-2005, 09:02 AM #55
    malik641
    malik641 is offline
    Forum Contributor
    Join Date
    06-10-2005
    Location
    Central Jersey
    Posts
    117
    Has anyone noticed that this thread has been repeating itself????
    -Joseph
    Reply With QuoteRegister To Reply
  56. 09-06-2005, 10:05 AM #56
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  57. 09-06-2005, 10:05 AM #57
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  58. 09-06-2005, 10:05 AM #58
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  59. 09-06-2005, 10:05 AM #59
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  60. 09-06-2005, 10:05 AM #60
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  61. 09-06-2005, 12:05 PM #61
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  62. 09-06-2005, 12:05 PM #62
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  63. 09-06-2005, 12:05 PM #63
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  64. 09-06-2005, 12:05 PM #64
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  65. 09-06-2005, 12:05 PM #65
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
  66. 09-06-2005, 03:05 PM #66
    RagDyer
    Guest

    Re: SUM every other 14th cell

    Check out this links of John McGimpsey:

    http://www.mcgimpsey.com/excel/formulae/doubleneg.html

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Thanks everyone!!! They all work great
    >
    > I have another question (REALLY simple)...I never understood why there
    > are the double dashes (or two minus signs, whatever you want to call
    > it) before certain functions (in this case, before the MOD function).
    > Why is that????
    >
    >
    > --
    > malik641
    > ------------------------------------------------------------------------
    > malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=387585
    >

    Reply With QuoteRegister To Reply
  67. 09-06-2005, 03:05 PM #67
    RagDyeR
    Guest

    Re: SUM every other 14th cell

    I'm sure John appreciates your appreciation!<g>
    --

    Regards,

    RD
    --------------------------------------------------------------------
    Please keep all correspondence within the Group, so all may benefit !
    --------------------------------------------------------------------

    "malik641" <[email protected]> wrote in
    message news:[email protected]...

    Good stuff. Thanks RD!


    --
    malik641
    ------------------------------------------------------------------------
    malik641's Profile:
    http://www.excelforum.com/member.php...o&userid=24190
    View this thread: http://www.excelforum.com/showthread...hreadid=387585


    Reply With QuoteRegister To Reply
  68. 09-06-2005, 03:05 PM #68
    Duke Carey
    Guest

    RE: SUM every other 14th cell

    =SUMPRODUCT(A1:A500,--(MOD(ROW(A1:A500),14)=1))

    "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
    >
    >
    Reply With QuoteRegister To Reply
  69. 09-06-2005, 03:05 PM #69
    Ashish Mathur
    Guest

    RE: SUM every other 14th cell

    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
    >
    >
    Reply With QuoteRegister To Reply
  70. 09-06-2005, 03:05 PM #70
    Paul B
    Guest

    Re: SUM every other 14th cell

    Malik641, try something like this,

    =SUMPRODUCT((MOD(ROW(A1:A1500)-CELL("Row",A1:A1500)+0,14)=0)*(A1:A1500))
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "malik641" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >


    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1