Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding the Average Change in Two Columns
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 |
#2
|
|||
|
|||
=(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 |
#3
|
|||
|
|||
This will work, but be warned, if you do not have values in any part of that
range (e.g. if B14 and C15 are blank), they will be considered 0 and will compute as "0 change" for one row. Must be entered with CTRL-SHIFT-ENTER =AVERAGE(C2:C15-B2:B15) "DadAtHome4" wrote in message ... 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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
This array formula will work:
=AVERAGE(B1:B15/A1:A15-1) Enter it with CTRL+SHIFT+ENTER, not just the ENTER key. On Wed, 9 Feb 2005 06:17:13 -0800, "DadAtHome4" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the names of the cells or columns from "A" to wha. | New Users to Excel | |||
how do i change column labels back to letters? currently columns. | Excel Discussion (Misc queries) | |||
How do I change the columns in excel back to alpha characters? | Setting up and Configuration of Excel | |||
Change number of columns mid page? | Excel Worksheet Functions | |||
Finding the average by dropping the lowest | Excel Worksheet Functions |