Help with (I believe) a COUNTIF function

  • Thread starter Thread starter kaz_zz
  • Start date Start date
K

kaz_zz

I require help with a function or formula I need to use. I have textual
data in cell A1, A2, and A3. I want to use a COUNTIF (or other if
appropriate) to count any textual data in a certain range (a1:a50)
EXCLUDING certain cells. How would I do that?
 
=countif(a1:a10,"test")+countif(a21:a30,"test")+.....

or (depending on your data layout):
=countif(a1:a50,"test")-countif(a21:a30,"test")

(I'd try to use the fewest number of countif()'s.)
 
Back
Top