Derive Average

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

ryguy7272

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...
 
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---
 
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---
 
=4*B5-SUM(E5:G5)
--
David Biddulph

ryguy7272 said:
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---
Click to expand...
 
=4*B5-SUM(E5:G5)
--
David Biddulph

ryguy7272 said:
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---
Click to expand...
 
Of course! It’s amazing how sometimes you go off on a tangent, and just
can’t see the solution, even when it is staring you right in the face.
Thanks David!!
Ryan--
 
Of course! It’s amazing how sometimes you go off on a tangent, and just
can’t see the solution, even when it is staring you right in the face.
Thanks David!!
Ryan--
 
Back
Top