+ Reply to Thread
Results 1 to 2 of 2

Conditional summing across multiple worksheets?

  1. #1
    Registered User
    Join Date
    10-05-2009
    Location
    NC, USA
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    1

    Conditional summing across multiple worksheets?

    Hello,

    I am an intermediate Excel user and can't seem to write a function to return the correct information.

    I want to conditionally sum information contained on multiple worksheets and then have the sum display on a summary.

    I am tallying expenses, each of which is one of four expense type categories. Thus, each worksheet contains columns for description of expense, amount of expense, and expense type. There are numerous worksheets in the workbook, as each worksheet represents a different GL account.

    I want to be able to to tell Excel to look through every worksheet in a workbook, find expenses tagged as a specific expense type category, then sum them and display that figure in the summary sheet.

    Any help is hugely appreciated!

    Thanks,
    Mandy

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Conditional summing across multiple worksheets?

    See here for tips and sample workbook:

    http://www.xl-central.com/sum-single...le-sheets.html
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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