Forum Discussion
Solved
A couple of formulas having problems with
Hi guys, I have two formula's I'm having problems with. One is with CountIF - I'm not sure it's the right formula to be using. I have a range of cells containing "Yes" or "No". I'd like the ...
Hi Bob,
You're a genius! Thanks a million. Both worked beautifully.
Alison
Alison,
You're on the right track, you just have to nest the Countif formula inside the If formula like:
=IF(COUNTIF(A2:L2,"Yes")>0,"Referral","No")
Edit -
I completely missed the second part of your original post, and apologize. For your second question, try this
=IF(AND(AG7=1,AH7=1),"Referral","No")
Hi Bob,
You're a genius! Thanks a million. Both worked beautifully.
Alison