need a formula

[Guest]

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.

 

[N Harkawat]

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

 

[David McRitchie]

=COUNTIF(L2:AB2,1) + COUNTIF(L2:AB2,2) + COUNTIF(L2:AB2,3)

 

[Guest]

try
= countif(L2:AB2,1)+countif(L2:AB2,3)

 

[Guest]

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]

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