Not sure what you need Can you describe the way the data is structure in the
w/sheet may be with a small example

"WAgrapher" wrote in message
...
This gives me the SUM of the number of 1s and 3s for each record. I need
to
know the numer of records (each is a customer) who buy any products from a
certain category (as indicated by a 1 or 3 in columns L through AB). One
customer could use one products and another could use all 17 and each
would
still only be counted once.

"N Harkawat" wrote:

=SUM(COUNTIF(L2:AB2,{1,3}))


"WAgrapher" wrote in message
...
Looking for a formula to tell me how many recrods there are in my
worksheet
where any field L2 through AB2 is equal to 1 or 3. Values in these
columns
range from 0-5.