Calculating Averages

[johntom123]

I am very new to excel. I have a spreadsheet with data like the one below and there are a couple things I would like to do.

excel test 6-7.png

I would like to be able to input the numbers into the rows for each month, then once finished have excel calculate the average of all the numbers for that month and display that number in the grey box to the right.

Also, if I decided that I only wanted 3/5 of the numbers then is there a way to easily select only 3/5 and have excel calculate the average for those 3 numbers?

Finally...

To the right of the "average box" can excel autimatically calculate what is the average + 10%?
Thanks in advance, this forum has been a big help. Let me know if this is too much for one thread or if I need to clarify anything.
Thank you,

[johntom123]

I figured out how to calculate the average using something like this. AVERAGE(B247:B251). But for an ongoing document, is there a way to have excel do this automatically so that I wouldn't have to choose the rows each time?

Thank you

[avk]

Try with this :
Suppose date from "A2" to "A6"
Amount from "B2" to "B6"
Criteria date in "C1" like 16/4/2018
Formula in "C2" :

Please Login or Register  to view this content.

In "D2" :

Please Login or Register  to view this content.

Enter 10% in "E2"

[JohnTopley]

Look at AVERAGEIF/AVERAGEIFS where you can choose criteria : for example dates for start/end month

You can reference whole columns OR set ranges to likely maximum