Thanks, Bernard Liengme.

Never would I have been able to figure that out!

Still not able to get it to work the way I want it to.

I made some changes to the sheet, so the cell numbers have changed. Maybe I
should try to explain another way.

I have two MPG columns. Column F shows my One Tank Avg (what any one would
get if they check their mileage after filling up. Column G has my Five Tank
Avg (=IF(G260,MIN(G8:G26),"").)

Next, I have two High Avg columns. J is the One Tank High Avg, and K is the
Five Tank High Avg.

On my test sheet, I have entered on rows 4-26, enough info to get my one and
five tank averages in columns F & G.

Using your first formula, I had to change Average to Min, and it will do
want I want, but only if columns F & G have figures in them. Columns F & G
have the formulas to figure out the answers as I continue to add fuel
fill-ups to the list. If I change your formula =IF(G260,Average(G8:G26),"")
to read =IF(G270,MAX(G8:G27),""), with row 27 not having any figures to
work with, but only a formula, then the answer in cells J3 & K3 (which is
where I want the single-most One & Five Tank high average from columns F & G
to show, does not give me a number. Instead, it shows #DIV/0!.

I need the formula for cells J3 & K3 to be able to adjust to the fact that I
will continue to enter info that will show up in columns F & G, and if those
averages are higher then what was previously recorded in J3 or K3, the it
will change.

If I can figure out how to get one column to update when new figures are
entered, then it will be easy enough to adjust it for the other one.

The second formula you provided doesn't work. I get an error message. As for
retirement- mine wasn't by choice, it was for medical reasons. If I had the
years in for a normal retirement, I think I would have be a little happier.

Bernard Liengme wrote:
Great!
Replace the formula by =IF(F50,AVERAGE(F3:F5),"")
The item after the last comma is double quotes in a row.
This say: IF the value is F5 is greater than 0, then do the
calculation, else display nothing.

My old math teacher- an Irishman - was fond of saying "There are more
ways of killing a pig than stuffing it with butter", so here is
another formula to try
=IF(COUNT(F3:F5)<3,"",AVERAGE(F3:F5))

How do you like retirement? This is my first month!