isrdebie wrote:
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.


I think you could use a SUMPRODUCT function, but it's quite impossible
without a sample of data... It could be very simple if you could upload a
sample file to www.savefile.com or www.rapidshare.de...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy