Forum Discussion
Formula help If(Countif for multiple range)
I am trying to write a formula to count a singular "1" if any number of No's appears within 2 distinct ranges. So if no in B30, and/or B33:37 need to count as 1 what I have now is. =IF(Coun...
Hi Jordan,
As for formula question you may use
=(Countif('Sheet 18'!B33:B37,"no")>0)*('Sheet 18'!B30="no")
Hi Sergei! I appreciate your assistance. I tried your formula, but unfortunately I am finding that it is not working. Perhaps you can help me see what I have done wrong?
please and thank you!