Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Derive Average
I have a year end number (Cell B5) and I can derive my Q4 number by summing
Q1 + Q2 + Q3, and subtracting the result from Q4. How do I do this for an average? I know my averages are wrong when I look in the bottom right corner of Excel, for the 'quick calculation'. When I mouse-over this range, I should see a number that equals the year end number... -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derive a formule for finding the average | Excel Worksheet Functions | |||
What formulae to derive? | Excel Worksheet Functions | |||
Derive an equation from plotted data | Charts and Charting in Excel | |||
Need to derive combinations for 4 elements each with 3 possible va | Excel Worksheet Functions | |||
Using on one list derive from another | New Users to Excel |