excel - CountIF with multipe variables -


im trying write formula in excel count number of rows "yes" in column j if column has entries "bjj" or "kb".

this have tried far, doesnt work:

countif(or(i1:i100,"bjj",i1:i100,"kb")),j1:j100="yes"

=sum(countifs(j1:j100,"yes",i1:i100,{"bjj","kb"}))

regards


Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -