AVERAGE Function: How Do I Exclude A Specific Range of Values?

Hello, everyone, I am requesting help with a formula. I have a very basic, easy, rudimentary spreadsheet that keeps track of my electric bills.

Attached to this message is a copy of the spreadsheet. As you can see, it has a cell for the average of all the bills.

What I'd like to do is create a cell that displays the average for all the bills that are under 90 dollars (which are all part of Column B). I'd like to exclude from this calculation any and all bills that are $90.00 and over. I'm not sure how to do that.

Do I use the Averageif or Averageifs options? Or do I just need to modify the Average option?


Thank you. Jd

View attachment Excel Average Question.docx

Please attach the workbook (.xlsx) file, not a picture of it.

Oops, my apologies...I uploaded the wrong file. Here is the correct one.

I've figured out how to do what I want. The formula is this: =AVERAGEIF(B2:B55,"<90")

I can change the B55 to a larger number, but that formula appears to work.

Try
Pay attention to the delimiter. (comma or semicolon)