Thread: easy way to Consolidate Data within workbook's various worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn
 
Posts: n/a
Default 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 With QuoteReply With Quote