Forum Discussion
Solved
Countifs Multiple Columns per Row
Hi everyone, I would like to achieve a COUNTIFS Function on 3 columns. If the criteria is NO, then it counts as 1. How can I achieve this in Excel? Currently I'm using =COUNTIFS Funct...
You may use
=SUM(--(Q2:S2="No"))as it is if your Excel supports dynamic arrays, otherwise enter as array formula or use SUMPRODUCT instead of SUM
Try:
=--OR(B1:D1="NO")
and you may need to hit Ctrl+Shift+Enter after keying/typing into the formula bar.
=--OR(B1:D1="NO")
and you may need to hit Ctrl+Shift+Enter after keying/typing into the formula bar.
Sorry, I misunderstood the question. If I understand correctly now, then Sergio's formula will work for you.
And, as Peter stated, I think regular countif will do what you need.
=COUNTIF(C1:E1,"No")
And, as Peter stated, I think regular countif will do what you need.
=COUNTIF(C1:E1,"No")