Forum Discussion
Help with an If And OR formula
Good afternoon, I'm looking for some help with writing a formula. I have an excel sheet that I am trying to write an If then formula with an OR and AND statement built in. Essentially if any cell i...
Sarah,
try this:
=IF(SUM((COUNTIFS(AG3:AQ3,{"Checked";"Unchecked"})>={1;11})*COUNTIFS(DH3,{"<1";">0"})),"Review","Okay")