+ Reply to Thread
Results 1 to 2 of 2

sum rows based on sub-total

  1. #1
    Registered User
    Join Date
    05-01-2015
    Location
    Vancouver, BC
    MS-Off Ver
    2010
    Posts
    35

    sum rows based on sub-total

    Hello Excel Gurus,

    I'm looking for a formula or vba code that will calculate a total (or sub-total to be more precise) for rows that are constantly changing (i.e. dynamic range).

    I have attached a spreadsheet for more information which is like a payroll time sheet.

    In it, I have to go to each 'sub-total' row to calculate the sum for the activity for that particular location. As there are hundreds/thousands of rows I have to repeatedly hit the sum function for every sub-total line.

    I've currently done this in cells:

    F9 and G9
    F20 and G20
    F24 and G24
    F32 AND G32

    I'm wondering if there is an easier way to calculate all the rows that have a sub-total as an identifier. Either in the form of a formula/vba-code?

    Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: sum rows based on sub-total

    There is a duplicate post of this question here:
    http://www.excelforum.com/excel-form...sub-total.html
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

+ 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. Replies: 1
    Last Post: 05-13-2015, 12:52 PM
  2. Delete Duplicate Rows based on one duplicating value- and keep total at the top the same.
    By jeremynorthwestern in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2014, 01:32 AM
  3. randomized rows based on percentage of total rows
    By Uwantachat in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 04-10-2014, 12:48 PM
  4. Replies: 1
    Last Post: 01-30-2013, 12:12 PM
  5. [SOLVED] Copy data to different sheet based on filter and add total rows
    By ravibemail in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2012, 07:25 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