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
COUNTIFS handles 2D ranges perfectly well although it is not widely used in this way.
= COUNTIFS(range, "NO")
where 'range' might be
=Table1[[Column1]:[Column3]]
The catch is that the criterion ranges must be actual range references and not just arrays and, where there are multiple criterion ranges, they must all be of identical size.