Using 2003 for awhile now, but running into a brick wall. Have a client
with an inventory workbook with 156+ worksheets. Each sheet represents
an artist with columns of: title & medium, size, received, date,
price, date sold, invoice, paid, comments, balance, type. There is a
summary sheet we created to show how much is in inventory for each
artist. That was easy enough. Just ran a total on each worksheet,
then had the summary sheet read that worksheet and cell.

Now we need to figure out year to date sales for each artist. I have
been searching the Internet and my Excel 2003 for dummies book, but no
luck on how to pull up that info. The summary sheet shows only the
artist name, amount in inventory, and year to date sales. I want to be
able to tell the summary sheet to read the artist sheet for a date sold
range, then pick up the paid amount. One problem is that inventory
that came in two or three years ago might not sell until this year, so
there are varying dates in the database. I think I need to SUMIF or
COUNTIF my PAID column (which is a dollar amount) and the IF would be
if the range of DATE SOLD column is between 1/1/06 and 12/31/06, but I
can't quite make it over the hurdle. If there is anyone out there who
can help, I would greatly appreciate it.


--
isrdebie
------------------------------------------------------------------------
isrdebie's Profile: http://www.excelforum.com/member.php...o&userid=37798
View this thread: http://www.excelforum.com/showthread...hreadid=573604