Please help

[Kuroo]

Hi. I want to get my daily average but i dont know how. I have 7 days, i want to get 600 divide day 4 next day 700 divide day 5 and automatic into daily average row. Is this possible?
I have a table like this
Day1 150
Day2 300
Day 3 400
Day 4 600
Day 5 700
Day 6.....
Day 7.....
Daily average:

 

[Alex Blakenburg]

The basic average function will ignore blank rows.
So just using this should do what you seem to be asking

=AVERAGE(B$2:B$8)

 

[jasonb75]

i want to get 600 divide day 4 next day 700 divide day

That is not an average, an average would be (150+300+400+600)/4 or (150+300+400+600+700)/5 etc. Looking at your question, I think that this is closer to what you are asking for.

Book2.xlsx
	A	B
2	Day1	150
3	Day2	300
4	Day3	400
5	Day4	600
6	Day5	700
7	Day6
8	Day7
9	Average	140
Sheet2

Cell Formulas
Range	Formula
B9	B9	=LOOKUP(1E+100,B2:B8)/COUNT(B2:B8)

 

[Kuroo]

That is not an average, an average would be (150+300+400+600)/4 or (150+300+400+600+700)/5 etc. Looking at your question, I think that this is closer to what you are asking for.

Book2.xlsx
	A	B
2	Day1	150
3	Day2	300
4	Day3	400
5	Day4	600
6	Day5	700
7	Day6
8	Day7
9	Average	140
Sheet2

Cell Formulas
Range	Formula
B9	B9	=LOOKUP(1E+100,B2:B8)/COUNT(B2:B8)

Thank you for helping me, this is grate. Thank you very much

 

[Peter_SSs]

That is not an average,

It is if the column B figures are a cumulative total, which it looks like it might be.
If that is the case, another option would be:

21 09 05.xlsm
	A	B
2	Day1	150
3	Day2	300
4	Day3	400
5	Day4	600
6	Day5	700
7	Day6
8	Day7
9	Average	140
Average

Cell Formulas
Range	Formula
B9	B9	=MAX(B2:B8)/COUNT(B2:B8)