+ Reply to Thread
Results 1 to 6 of 6

summing across multiple worksheets based on category

  1. #1
    Registered User
    Join Date
    07-23-2019
    Location
    Austin, TX
    MS-Off Ver
    2013
    Posts
    16

    summing across multiple worksheets based on category

    I have 3 worksheets and in these worksheets there are multiple rows that I have categorized as such:

    Equipment
    Education
    Fees

    Each of these rows have an associated dollar amount, all unique numbers.
    on a 4th worksheet I want to reference all same categories together and sum the totals across the 3 worksheets.

    So on that 4th worksheet my result would be something like this:

    Equipment $45439.12
    Education $ 2700.01
    Fees $ 850.00

    Thank you

  2. #2
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    100

    Re: summing across multiple worksheets based on category

    Could you do a SUMIFS formula?

    Example:
    Sheet1 - Column B = Price and Column A = Category
    Sheet2 - Column C = Price and Column D = Category
    Sheet3 - Column B = Price and Column A = Category
    Summary Worksheet Cell A4=Equipment, A5= Education, and A6=Fees

    In Summary Worksheet Cell B4 =SUMIFS(Sheet1!B:B,Sheet1!A:A,A4)+SUMIFS(Sheet2!C:C,Sheet2!D:D,A4)+SUMIFS(Sheet3!B:B,Sheet3!A:A,A4)

  3. #3
    Registered User
    Join Date
    07-23-2019
    Location
    Austin, TX
    MS-Off Ver
    2013
    Posts
    16

    Re: summing across multiple worksheets based on category

    Attachment 768200

    Here is an example of one worksheet. Notice I have multiple rows of the same subcategory. This occurs on 2 other worksheets. I want to group together all "fees" dollar amounts ie, onto the new worksheet as a sum total.

  4. #4
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    100

    Re: summing across multiple worksheets based on category

    I am unable to download, states it is an invalid workbook. Can you try to upload an example workbook again?

  5. #5
    Registered User
    Join Date
    07-23-2019
    Location
    Austin, TX
    MS-Off Ver
    2013
    Posts
    16

    Re: summing across multiple worksheets based on category

    its just a screenshot for illustration.
    Here is a copy of the rows and columns

    Category Date Amount
    Equipment 1/4/2021 -20
    Fees 2/18/2021 -16.41
    Education 3/8/2021 -268.53
    Fees 3/11/2021 -48.23
    Fees 3/15/2021 -16.07
    Subscriptions 3/15/2021 -29.99
    Fees 4/19/2021 -5
    Fees 4/26/2021 -2.52
    Equipment 5/20/2021 -105
    Repairs 6/1/2021 -460
    Auto 6/11/2021 -257
    Auto 6/28/2021 -5.01
    Auto 7/6/2021 -63.59
    Equipment 8/18/2021 -149.99
    Repairs 9/24/2021 -210

  6. #6
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    100

    Re: summing across multiple worksheets based on category

    Did this attachment work?
    Attached Files Attached Files
    Last edited by mphillips; 02-14-2022 at 06:56 PM.

+ 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: 10-30-2018, 07:38 PM
  2. Replies: 8
    Last Post: 09-06-2017, 12:47 PM
  3. Summing across multiple worksheets
    By atmullan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-27-2014, 05:40 PM
  4. Summing across multiple worksheets
    By AberdeenGDK in forum Excel General
    Replies: 9
    Last Post: 02-20-2012, 03:14 PM
  5. [SOLVED] summing multiple worksheets
    By Kamie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-03-2006, 02:20 PM
  6. [SOLVED] Summing Data based on Its Category
    By sip8316 in forum Excel General
    Replies: 2
    Last Post: 05-24-2005, 03:06 PM
  7. Summing multiple worksheets
    By WesProbus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2005, 10:09 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