# Average function without a set number

0

I work at a hotel and I have a form that I use at work to calculate the time/number of rooms being done. I have the formulas all set up to calculate some of it but I still have to average out the minutes from all the different groups. If I have a set number of groups, I would be able to just put the formula in but somedays I have 6 times to average, somedays I have 8. The number varies. Is there a formula to use where I could set up the average function and just put in the number of items?

For example: One day I could need to average out 1.52, 1.65, 1.89, 1.48, 1.59 and the next day I could have to average out 1.52, 1.65, 1.89, 1.48, 1.59, 1.12, 1.87, 1.45, 1.26.

And the numbers aren't all in a row, they are spread out. So right now I am just using the = then selecting all the cells to add together and then in a different cell, I divide that by however many numbers I have. I'd like to be able to do that all in one cell. Is that possible?

0

You you the AVERAGE() function like this:

``=AVERAGE(A2,A4,A7,A9:A10)``

Type a comma and then select the next cell or range that you want to average.