Confused

[i8ig]

I need to count the number of times 'settled' and 'impasse' occur in a row and add the total together, I tried: =countif("settled"and"impasse") but it does not work

Any suggestion is appreciated

 

[i8ig]

Never mind, I found that if I left the and out it works fine

 

[Gerald Higgins]

Why not
=countif("settled") + countif("impasse")

Obviously the exact code will be different.

 

[Thorin]

You could try :-

=COUNTIF(A4:A11,"settled")+COUNTIF(A4:A11,"impasse")

Where A4:A11 is your range.

 

[shekhar_pc]

Try =COUNTIF(A1:IV1,"settled")+COUNTIF(A1:IV1,"impasse")

If the above does not work, can you put a sample data?