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.