Sep 14 2021 08:47 PM
I have 3 cells with numbers E20 is 5, F20 is 2 and Y20 is 3.
In cell Z20:
=IF(Y20>F20,IF(Y20<E20,1,"")) gives me 1
However,
=COUNTIFS(Y20,">F20",Y20,"<E20") gives me 0
I can't figure out what happened. I have checked using isnumber() that all values are in fact numbers.
I need to use the countifs formula, please help.
Sep 14 2021 10:37 PM
SolutionSep 14 2021 10:53 PM
@Detlef Lewin Thank you so much! it works now!!
Sep 14 2021 10:37 PM
Solution