| 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''. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Derive Average
How about:
=B5/4 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ryguy7272" wrote in message ... 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''. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Derive Average
ryguy7272 wrote:
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... Huh? This is circular and cannot work as you described. You cannot "derive Q4 by summing...and subtracting the result from Q4" Explain further? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Derive Average
Ok, let's say this is the setup:
Cell B5 = 25 Cell E5 = 15 Cell F5 = 30 Cell G5 = 28 Cell D5 is unknown I want B5 to represent the average of Range("D5:G5"). What function do I put in Cell D5? Thanks, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "smartin" wrote: ryguy7272 wrote: 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... Huh? This is circular and cannot work as you described. You cannot "derive Q4 by summing...and subtracting the result from Q4" Explain further? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Derive Average
=4*B5-SUM(E5:G5)
-- David Biddulph "ryguy7272" wrote in message ... Ok, let's say this is the setup: Cell B5 = 25 Cell E5 = 15 Cell F5 = 30 Cell G5 = 28 Cell D5 is unknown I want B5 to represent the average of Range("D5:G5"). What function do I put in Cell D5? Thanks, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "smartin" wrote: ryguy7272 wrote: 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... Huh? This is circular and cannot work as you described. You cannot "derive Q4 by summing...and subtracting the result from Q4" Explain further? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Derive Average
Of course! Its amazing how sometimes you go off on a tangent, and just
cant see the solution, even when it is staring you right in the face. Thanks David!! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "David Biddulph" wrote: =4*B5-SUM(E5:G5) -- David Biddulph "ryguy7272" wrote in message ... Ok, let's say this is the setup: Cell B5 = 25 Cell E5 = 15 Cell F5 = 30 Cell G5 = 28 Cell D5 is unknown I want B5 to represent the average of Range("D5:G5"). What function do I put in Cell D5? Thanks, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "smartin" wrote: ryguy7272 wrote: 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... Huh? This is circular and cannot work as you described. You cannot "derive Q4 by summing...and subtracting the result from Q4" Explain further? |
| Reply |
| 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 | |||
Linear Mode
