+ Reply to Thread
Results 1 to 3 of 3

Auto Generate Sum Function After 20 rows

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Auto Generate Sum Function After 20 rows

    hello
    target range = G10:G10000

    i want to sum of range ("G10:G29") In cell ("T10") and next sum of ("G30:G49") in cell ("T30") and next sum of ("G50:G69") in cell ("T50")

    i mean sum of 20 rows of column G, and after 20 rows of column T,

    thanx

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Auto Generate Sum Function After 20 rows

    Write this in T1 and pull formula down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Re: Auto Generate Sum Function After 20 rows

    Works perfect

    thanx a lot Mod zbor

    will add u reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto sorting/filtering data without empty rows to generate scatter plots
    By turkeyusa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-15-2014, 02:05 PM
  2. Generate Auto ID
    By Shazz in forum Excel General
    Replies: 8
    Last Post: 05-03-2013, 06:23 AM
  3. Generate Columns depending on the number of rows filled(VBA / BDH function)
    By bryan444 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2012, 04:27 AM
  4. generate a random number and use if function to generate new data
    By Dogdoc1142 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2006, 10:50 PM
  5. Auto Generate a new row
    By fanny_magnet in forum Excel General
    Replies: 0
    Last Post: 04-28-2005, 11:29 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1