+ Reply to Thread
Results 1 to 4 of 4

How to insert pagewise (subtotal) total for columns

  1. 05-03-2018, 06:01 AM #1
    jilaba
    jilaba is offline
    Forum Contributor
    Join Date
    02-27-2009
    Location
    Chennai, India
    MS-Off Ver
    Excel 2013
    Posts
    327

    How to insert pagewise (subtotal) total for columns

    I've attached forum.xlsx which has data in A & B columns.

    I have to get pagewise (subtotal) total for these columns (under the last row). How to do this?
    Attached Files Attached Files
    Last edited by jilaba; 05-03-2018 at 06:25 AM.
    Ask me how to hate XL.
    Reply With QuoteRegister To Reply
  2. 05-03-2018, 04:44 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,602

    Re: How to insert pagewise (subtotal) total for columns

    Am I missing something?
    =SUM(myRANGE)
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 05-04-2018, 01:28 PM #3
    jilaba
    jilaba is offline
    Forum Contributor
    Join Date
    02-27-2009
    Location
    Chennai, India
    MS-Off Ver
    Excel 2013
    Posts
    327

    Re: How to insert pagewise (subtotal) total for columns

    Quote Originally Posted by protonLeah View Post
    Am I missing something?
    =SUM(myRANGE)
    can you please illustrate
    Reply With QuoteRegister To Reply
  4. 05-09-2018, 11:30 AM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: How to insert pagewise (subtotal) total for columns

    Paste the following into cell A111 and drag the fill handle over to B111: =SUM(A2:A110)
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    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. Insert new row before sub total
    By Peterino in forum Excel General
    Replies: 13
    Last Post: 11-28-2017, 04:29 PM
  2. Looking for a macro to move 2 columns over creating an advancing loop (total 30 columns)
    By clundeen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2017, 12:53 PM
  3. [SOLVED] Macro to combine Qty and Price Columns separated by Total Columns
    By prkhan56 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-17-2017, 02:46 AM
  4. [SOLVED] Multiplying the results of two columns of sums - Total Billed and Total Paid
    By stuprice in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-02-2017, 04:23 PM
  5. copy selected rows(Check boxes) & Auto insert Sub Total & Grand Total option with Formula
    By rana19 in forum Excel General
    Replies: 1
    Last Post: 05-13-2015, 12:52 PM
  6. [SOLVED] Macro to Insert two columns to the left of a moving total column
    By Jmoreau in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2013, 11:23 AM
  7. [SOLVED] unable to insert columns in excel, insert-> columns (disabled)
    By iam_leearner in forum Excel General
    Replies: 1
    Last Post: 08-13-2006, 09:26 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1