ok was just proposing that you have a summuray of the 3 columns, if you don't want that you can use sumproduct

=SUMPRODUCT((I2:I8=2)+(P2:P8=2)+(W2:W8=2)) -> for values of 2's
=SUMPRODUCT((I2:I8=1)+(P2:P8=1)+(W2:W8=1)) -> for values of 1's

regards,
vladimir