I’m relatively new here in Excel, so pardon if this question might sound like an amateur.
I’m trying to use COUNTIFs to calculate the numbers between the range. The data (let’s say it is in column E) is being compared to values within other cells (I5 and I6)
So the formula I written is
However it does not work. When I replace the columns with values that they hold respectively however, it works fine. Can somebody please help?
Thanks in advance