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''.