Hello. I want to average a column if 2 criteria are met. I googled and searched this forum to no avail.

I want to average H6:H60000 if the data are above 4 and below 100. The below formula does not work.

=AVERAGEIFS(H6:H60000,H6:H60000,">4",H6:H60000,H6:H60000,"<100")

Thanks for any help!