One way ..

Assuming data in cols C to K, from row2 down with no blank cells (cells will
house zeros as per sample posted)

Put in L2:
=COUNTIF(C2:K2,"<0")
Copy down

Then with the numbers: 1 - 9 listed in say N2:N10
Put in O2: =COUNTIF(L:L,N2)
Copy down to O10. O2:O10 will return the required customer counts by number
of SKUs listed in N2:N10, viz. your line:
.. how many customers take 1 SKU, 2SKU's, 3SKU's etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Des" wrote in message
...
Hi Mark

Thanks for prompt response.

The table looks something like this

52000 52001 52002 52003
Cust No Name Units
111 Co A 20 10 0 30
112 Co B 10 0 20 5
etc

Unfortunately this is how it's set out and it comes directly from our
system, so I don't want to go another route with formatting it differently
(customer list is several 1000). I have many other variables to this as
well, like adding say a Division, Channel etc to each customer and these
would typically be inserted in Column A, B with Cust No and Name after
that.

Cust No A2:A11
Cust Name B2:B11
SKU C1:K1

I'm guessing that the suggested formula needs to change based on the
above?
Apologies, I should have made this clearer.

I do tons of this sort of analysis - and do it in a roundabout way, but
it's
time consuming and time for me to learn to do it properly!

Thanks, Des