need a formula
 

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.

=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.

=COUNTIF(L2:AB2,1) + COUNTIF(L2:AB2,2) + COUNTIF(L2:AB2,3)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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.

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

"WAgrapher" wrote:

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.

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.

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.