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