It would help if you told us how you had set out your data and what formulas
you are using.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Retiredff" wrote in message
ink.net...
Right off the top, let me say that I know next to nothing about Excel and
how to use formulas. I have spent several hours over the last two days
looking for an answer, and if I found it, I did not recognize it.
I may be trying to re-invent the wheel, but here is my problem.
I am setting up a spreadsheet to track short and long-term fuel economy.
Single tank MPG was no problem. I have succeeded in getting it to work so
that it will give me a running average for three and fifteen tank fills.
I want to be able to track the minimum and maximum MPG in each of the
three categories (single, three, and 15 tank). I can get it to work as
long as I have entries in those categories. I can't figure out how to get
it to check (compare?) as I add additional fill-ups to my list.
For instance, if I select the entire one-tank column, and use that range
in my formula, I wind up with #DIV/0! as the answer, even though there are
averages listed. If I only select the columns that have an entry, then I
get the correct figure.
I hope this is clear enough so someone will understand what I am trying to
do.
Many thanks.
Larry