exclude a cell using =average

[still learning]

Hi

I use the following to keep track of my gas millage

How would I change it to NOT include F90

=IF(A91="","",AVERAGE($F$78:F91))

mike

 

[hagia_sofia]

Hello, do you mean:

=IF(A91="","",AVERAGE(F78:F89,F91))

 

[still learning]

Hi hagia_sofia
Sort of.
I have numbers from F78 down.
I dragged the formula down to F200.
I start at F78...($F$78) and have a running average if there is a date in A...
I'm down to F91 with averages, so far
I want to be able to NOT include a cell in F in the average (F90) if the number is less than 20
I know i can change the value to 0 but it will still be included in the calculation
Your formula will work, but I was looking for a formula that I wouldn't have to change if I didn't want to use the number in a cell in F
Is the an if formula that would ...=if A91="","",AVERAGE($F$78:F91 but don't include and number that is less than 20)
mike

 

[Peter_SSs]

Would be easier to understand what you have and what you want if you provided some sample data and expected results with XL2BB

Is it one of these that you are after?

24 09 03.xlsm
	F	G	H
78	35	35	35
79	68	51.5	51.5
80	2	51.5
81	0	51.5
82		51.5
83	89	64	64
84	25	54.25	54.25
Average excluding

Cell Formulas
Range	Formula
G78:G84	G78	=IF(A$91="","",AVERAGEIFS(F$78:F78,F$78:F78,">=20"))
H78:H84	H78	=IF(A$91="","",IF(F78<20,"",AVERAGEIFS(F$78:F78,F$78:F78,">=20")))

 

[still learning]

Thank you all for your reply. I'll make up a sample sheet and post it with XL2BB
It'll take a cover of days.
I realized that I've got my columns labeled wrong in the question. I bet I'm the only one that has ever done that

 

[still learning]

Thank you both for helping me.
I reread Peter's reply and was able to get the results i needed.
Sorry it took so long for a comeback
mike