I did say a Pivot Table would be a far better idea.

However, I you truly do have over 200,000 Unique Items, then Excel is
not the answer for you (currently), as there is a limit of 65536 rows
per sheet. Assuming that more than one customer bought at least one of
these items, then the size of the database will be huge and needs to be
in a database application, not in a spreadsheet.

--
Regards

Roger Govier


"JCowell" wrote in message
...
I am trying to do this for over 200,000 unique items and hundreds of
customers.

I can't put item in F2 for thousands of items. Can I?

"Roger Govier" wrote:

Hi

One way, put Product item in F2 and Customer name in G2
=SUMPRODUCT(--($A$2:$A$1000=F2),$C$2:$C$1000) for total Product units
sold
=SUMPRODUCT(--($B$2:$B$1000=G2),$C$2:$C$1000) for Total sold to a
given
Customer
=SUMPRODUCT(--($A$2:$A$1000=F2),--($B$2:$B$1000=G2),$C$2:$C$1000) for
Given Customer and Given product


Better still, create a Pivot Table and see an analysis of all
Customers
by all Products.
For help on setting up a Pivot Table take a look at Debra Dalgleish's
site and scroll down to Pivot Tables
http://www.contextures.com/tiptech.html
--
Regards

Roger Govier


"JCowell" wrote in message
...
I have a report that keeps track of:
Product #, Customer #, Qty Sold for every invoice on a specific
date

I want to add/SUM all the (Qty Sold) for all Like (Product #'s)
regardless
who they were purchased by. To give me my total units sold.

And also be able to SUM the (Qty Sold) for each specific Customer.
To
give
me that Customers Total Useage.