Forum Discussion
Using Cell Reference in CountIFS formulas
Here is my current formula: =COUNTIFS(H1:H100,"solo",D1:D100,"yes",E1:E100,"no") The Cell C12 contains the text "solo". I would like to be able to use a cell reference of C12 in the formula inst...
mikebeachphoto This should work:
=COUNTIFS(H1:H100,C12,D1:D100,"yes",E1:E100,"no")
or
=COUNTIFS(H1:H100,$C$12,D1:D100,"yes",E1:E100,"no")