Forum Discussion
COUNTIF function
I am trying to use the following COUNTIF formula =countif($f$7:$aj$7,”(f7/f6)>.95”) I am not getting a result and can’t figure out why. If I use the evaluate function it functions properly up until ...
Unfortunately this didn't work either. Row 4 contains an if formula that reads another sheet. The if formula returns " " if the cell in the other sheet is blank (if(isblank(Sheet1!A4),"",Sheet1!A4) for example. That is what is making this so difficult. SergeiBaklan
Adam_Speerstra , if in row 3 is number and in 4 is empty string, in 5 shall be #VALUE! which calculated by formula correctly. Perhaps you could give a sample of what exactly not works? You may type into the cell ="" to imitate returned by IF empty string