Forum Discussion
Solved
COUNTIFS with <>= and cell reference
Hello, my issue is that I am trying to count the number of observations between a range of values, and the COUNTIFS formula fits perfectly. If I write the formula as >=, <= and write the number it wo...
Carlos1290 Try writing the criteria similar to this (suppose A1 holds the number you want to use in the COUNTIFS:
"<=" & A1
Carlos1290 Try writing the criteria similar to this (suppose A1 holds the number you want to use in the COUNTIFS:
"<=" & A1
Thak you very much Riny_van_Eekelen That works perfectly!
