+ Reply to Thread
Results 1 to 2 of 2

How to shorten this sum formula?

  1. 07-11-2016, 11:00 PM #1
    mso3
    mso3 is offline
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    How to shorten this sum formula?

    Hi friends,

    I want to sum the cells step 13 endlessly in column ‘Z’. I need a short formula to avoide the following lengthy each time editable formula.

    Please Login or Register  to view this content.
    Any help will be highly appreciated.

    Thanking you in anticipation.
    Sincerely,

    mso3
    Reply With QuoteRegister To Reply
  2. 07-11-2016, 11:28 PM #2
    Phuocam
    Phuocam is offline
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,908

    Re: How to shorten this sum formula?

    Try this ...

    =SUMPRODUCT(--(MOD(ROW($Z$8:$Z$10000),13)=8),$Z$8:$Z$10000)
    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)

Similar Threads

  1. How to Shorten this SUM-AND-IF-OR Formula
    By sinfinite in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 08-14-2015, 06:22 PM
  2. Shorten Formula?
    By Sammz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2015, 10:11 AM
  3. Shorten formula?
    By jw01 in forum Excel General
    Replies: 1
    Last Post: 06-08-2015, 04:55 PM
  4. Please Shorten This Formula
    By jmcconville18 in forum Excel General
    Replies: 2
    Last Post: 08-18-2014, 01:21 PM
  5. way to shorten this formula?
    By tsiguy96 in forum Excel General
    Replies: 2
    Last Post: 04-03-2012, 08:28 PM
  6. Shorten a formula
    By asburytl in forum Excel General
    Replies: 2
    Last Post: 09-02-2011, 10:47 AM
  7. formula to shorten if need be
    By excellentexcel in forum Excel General
    Replies: 3
    Last Post: 03-04-2009, 01:50 PM

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