COUNTIF followed by another condition

[ericbss7]

So I have a COUNTIF statement that reads:

=COUNTIF(B2:B11,D2)

This returns a 1 if it finds an instance of D2 in B2:B11, or a 0 if it doesn't find it.

My question is that I'm trying to get this formula to also add a specific number if 0 instances are found. For the example above, I would like it to add 36 if it comes back as a 0, making the value of the cell 36.

Does anyone know how to do this? Thanks.

 

[cb12]

Try:

=IF(COUNTIF(B2:B11,D2)=0,36,COUNTIF(B2:B11,D2))

 

[ericbss7]

Try:

=IF(COUNTIF(B2:B11,D2)=0,36,COUNTIF(B2:B11,D2))

Yes that did it. Thanks a lot.