COUNTIF Statements

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

I would like to use a countif statement that has multiple
conditions.

Condtion 1 c:c = "yes"
condition 2 e:e = "no"

is there any way I can do this with countif. The only
workaround I can find is to create another column G with
formula =and(c1="yes",e=1="no") , then using

countif(g:g,true)

ui would like to avoid this though as the spreadsheet is
already huge

is it possible to solve this with 1 countif ?
 
Back
Top