Formula for COUNTIFS

Hi there

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

=COUNTIFS($E:$E,”>=$I$6″,$E:$E,”<$I$5″)

However it does not work. When I replace the columns with values that they hold respectively however, it works fine. Can somebody please help?

=COUNTIFS($E:$E,”>=76″,$E:$E,”<97″)

Excel 2016

Thanks in advance

 

By: 13

Leave a Reply

Your email address will not be published. Required fields are marked *