+ Reply to Thread
Results 1 to 2 of 2

easy way to Consolidate Data within workbook's various worksheets

  1. #1
    estimator
    Guest

    easy way to Consolidate Data within workbook's various worksheets

    Trying to Consolidate Data that meets defined conditions from one worksheet
    to another worksheet within the same workbook (in Excel 2003). Note: I am
    not an advanced Excel user.

  2. #2
    Kevin Vaughn
    Guest

    RE: easy way to Consolidate Data within workbook's various worksheets

    countif might work. Or perhaps sumproduct. A good explanation of how to use
    sumproduct is at http://www.xldynamic.com/source/xld.SUMPRODUCT.html
    --
    Kevin Vaughn


    "estimator" wrote:

    > Trying to Consolidate Data that meets defined conditions from one worksheet
    > to another worksheet within the same workbook (in Excel 2003). Note: I am
    > not an advanced Excel user.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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