See if this example helps, with 2 different methods for average difference:

http://www.exceltip.com/st/Calculating_the_Average_Difference_between_List_Price_and_Sale_Price_%09/795.html

Hint: click on spreadsheet on this page which is the link to an expanded sheet showing all the details.

Ron

RoHe,

I've checked all of Excel's help menu's and a number of websites to see if there was a function that would work for my problem, and I can't find any "cookiecutter" solutions.  Your suggestion would work if I were comparing differences between two separate lists.  Basically, the formula I'm looking for would be something like this:

(Final Entry minus First Entry) divided by (Total Number of Entries minus 1)  =  Average Difference, or to use my example in the original question -------

(376-150) / (5-1) = 56.5

 

I just don't know how to write the formula to make it work!

Art

Message Edited by abach on 08-20-200610:05 AM

mpo,

Perfect!  This is EXACTLY what I was looking for.  I said that I was new to Excel, but I also knew that it would be a fairly simple formula.  I worked it out myself, but I had to add an additional column of values to make it work.

Thanks again, and welcome to the Forum. :smileyvery-happy::smileyvery-happy::smileyvery-happy:

Art