| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average
Can anyone tell me what formula to use to average something like this:
$50K - 20% $40K - 20% $30K - 60% Where $50k has 20% of the weight, etc. Any help will be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average
=(50,000*.2+40,000*.2+30,000*.6)/3
Dave -- Brevity is the soul of wit. "Jordan" wrote: Can anyone tell me what formula to use to average something like this: $50K - 20% $40K - 20% $30K - 60% Where $50k has 20% of the weight, etc. Any help will be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average
With the dollar values in A1:A3 and the percentages in B1:B3 use
=sumproduct(A1:A3,B1:B3) "Jordan" wrote: Can anyone tell me what formula to use to average something like this: $50K - 20% $40K - 20% $30K - 60% Where $50k has 20% of the weight, etc. Any help will be greatly appreciated. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average
This got a loud *hoot* out of me here in the office. Something about
the misposted reply + your signature :) Thanks for the laugh Dave F wrote: =(50,000*.2+40,000*.2+30,000*.6)/3 Dave -- Brevity is the soul of wit. "Jordan" wrote: Can anyone tell me what formula to use to average something like this: $50K - 20% $40K - 20% $30K - 60% Where $50k has 20% of the weight, etc. Any help will be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rolling average | Excel Worksheet Functions | |||
| Modified Average Function | Excel Worksheet Functions | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| plotted Average | Charts and Charting in Excel | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
Linear Mode
