Forum Discussion

JORDAN BITTICKS's avatar
JORDAN BITTICKS
Copper Contributor
Aug 03, 2018

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...

Resources