|
|
#1
10-13-2012, 08:32 AM
|
|||
|
|||
the sum
I am new to excel and I need to modify the sum of price to determine the average issue price and average estimated market value by type. I am not sure how to do this. I posted a picture below showing what I am doing. Thanks for reading.
|
|
#2
10-13-2012, 11:47 AM
|
||||
|
||||
|
Hi
it's a nice picture but not very useful. Please post a sample sheet and a some more explanation
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
10-13-2012, 09:58 PM
|
|||
|
|||
|
Try AVERAGE, AVERAGEIF or AVERAGEIFS functions.
|
|
| Tags |
| average, sum |
|
|
Windows 7 64bit 
Office 2007
Linear Mode
