Hi Desiré,

Assuming your names are A1:A10 and your SKU numbers are in B1:B10, create a
list of client names down a column (I have started at F2) and in the next
column over (G2 in my case), try this formula:

=SUMPRODUCT(--($A$1:$A$10=F2),--(LEFT($B$1:$B$10,3)="SKU"))
--
Hope this helps,
MarkN


"Des" wrote:

Hi
I have 9 columns, each with a SKU no starting series 52000 though 52008
Rows are customer no and name

I want to calculate how many customers take 1 SKU, 2SKU's, 3SKU's etc and
put the result either on another tab, or at the end of the columns as listed
above.

How would I go about achieving that?

Many thanks
Desiré