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!
Bookmarks