Can this be done in Excel?

[PeterintheUK]

Hello, I wonder if anyone can help me whether this can be done in Excel?

I use Excel to help place students for work practice - one sheet is for each different student group and the other sheet is for the totals that an area can take.

I have about 5 different groups of students all going to one area at some point in the year - if you see the attached file you can see I've filled out a small example for weeks 1-5.

Is there anyway for Excel to tally what I input on the 'forecast' tab and automatically total it up in the 'totals' tab?

I've filled out 'Garden Wing' totals (with the maximum amount of students they can take at any one time in brackets) as an example in our previous way of merely plotting them as we go along. But as you could imagine it quickly gets very complicated and very time consuming when all students are being placed across all areas.

Is there a way of Excel automatically tallying up the totals for the remaining three areas?

Please say yes!

Many many thanks for any help.

[VegasL]

if I understand you correctly, use the sum function. I've attached updated spreadsheet.

[NBVC]

Peter,

Please take the time to read our forum rules and then amend your title to be more descriptive of the question. This helps in future Search functionality in the overall website.

Thanks for your cooperation and enjoy the forum.