Calculating average- one cell missing

[Ed10]

Hey I have 49 cells which represent profits for different quorters, I need to find their average. It is said it should be less than 400000 per quorter. Plus, the 49th cell is blank, I need to find its value without affecting the average. Please help me?

 

[etaf]

dont you just average the 48 values ? and use that for the 49th
then the 49 values should be the same average
Or am i missing something to the question

Not sure where the <400,000 would come in/from

perhaps put a sample sheet here - using XL2BB see menu / my signature

Book9
	A	B	C	D
1		1
2		20
3		300000	Average of 1-3 =	100007
4	use Average here	100007	New Average =	100007
Sheet1

Cell Formulas
Range	Formula
B4	B4	=D3
D3	D3	=AVERAGE(B1:B3)
D4	D4	=AVERAGE(B1:B4)

 

[Ed10]

This is where I find it weird too. Using formulas only is required so I try finding one which will include <400000 as well (maybe averageif?).Obviously this is my first time using Excel, it's supposed to be really basic...

 

[etaf]

sorry dont understand