counting unique numbers
=SUMPRODUCT(--(A1:A100<""),--(1/COUNTIF(A1:A100,A1:A10&"")),A1:A100)
Is unclear: Then in another set of cells per year I would like to get a
unique sum of all purchased parts.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Neall" wrote in message
...
I have a list of customers over the past 4 years, they are differentiated
by
customer numbers.
What I would like to do is in one cell per year give me a unique customer
count for that year.
Then in another set of cells per year I would like to get a unique sum of
all purchased parts.
Customer number is A1$1
End date is G1$1
Pricing is H1$1
Any suggestions
--
Neall