| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simplify Weighted Average Formula
I have a s/s that has the months of the year across the top and below 3
categories for each month and I want a weighted avg for each product. eg: A B C D E F G H I January February March etc. to Dec Days Oil Gas Days OIl Gas Days Oil Gas 6 12 200 4 5 180 7 8 300 formula: =(a1*b1+D1*E1+G1*h1)/(a1+d1+g1) Is there a way to simplify this? Thank in advance for any help. -- ferne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calulate the weighted average | Excel Discussion (Misc queries) | |||
| Formula for Weighted Average | Excel Discussion (Misc queries) | |||
| Moving Weighted Average formula | Excel Discussion (Misc queries) | |||
| calculating a weighted average using formula | Excel Worksheet Functions | |||
| What is the formula for weighted average? | Excel Worksheet Functions | |||
Threaded Mode
