Excel 2007 : Excel 2007 formulation

[rufus12]

Hi All,

I need help with this problem;


School Number of Students Number of Teachers Student/Teacher Ratio
Cleveland 741 43 17.23
Parkside 760 38 23.26
Powers 643 37 17.38
Lakeview 780 39 23.23
Sunnyslope 704 40 17.6
Praireview 715 41 17.44
Mountainview 793 40 19.83
Total 5136 278 19.37
of course it did not paste smoothly but, the idea is 741 is under # of students, 43 is under # of teachers, and 17.23 is under student/teacher ratio. I had no problem in calculating cleveland to mountainview, but when it came to the final ratio, I could not find the formula that would give me the final answer of 19.37, help please!!!!! I did an average of ratios and that gave me 19.42, what am I doing wrong??????????

[Pete_UK]

Try it by totalling all the students and all the staff.

Hope this helps.

Pete

[rufus12]

Try it by totalling all the students and all the staff.

Hope this helps.

Pete

Thanks, but it did not work

[rufus12]

Maybe this attachment will help, it gives a clearer picture of my problem.

[Pete_UK]

Well, I just copied the formula from D9 into D10 and it gave me the result that you were expecting.

Hope this helps.

Pete

[rufus12]

Well, I just copied the formula from D9 into D10 and it gave me the result that you were expecting.

Hope this helps.

Pete

@ Pete, YAYYYYYYYYYYYYYY! Thank you so much, maybe I should have had some coffee before doing this

[Pete_UK]

I find that coffee always helps !! <bg>

Perhaps you can mark the thread as Solved - the FAQ describes how.

Pete