Help with (I believe) a COUNTIF function

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?
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
countifs Function not giving desired result with date criteria 2
Using <= in countifs statement 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Multiple arguments 3
Counting occurences of text 3
Needs help combining functions. 3
Excel Countif Function - Calculating Between Two Sets of Values 3

Top