View Single Post
  #4   Report Post  
DadAtHome4
 
Posts: n/a
Default

This is good, how do I express the result in %, i.e. average change from List
Price to Sold Price is x%.

"ChrisJ" wrote:

=(SUM(B2:B15)-SUM(A2:A15))/COUNT(B2:B15)

"DadAtHome4" wrote:

Columns B and C
B:2B15 is List Price - C:2C15 is Sold Price
I want to show in another cell what the average change is between List Price
and Sold Price.

Appreciate the help, you folks have never steered me wrong.
Charles, Grand Rapids Michigan