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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks