Hi,
This should be easy but I'm struggling I am trying to calculate if cell AG = Open and if cell AY = Open OR Blank. Here is the formula I've used but it isn't calculating correctly =IF(OR(AY3="open",AY3=" ",AND(AG3="open")),1,0). Any help really appreciated!