kznmrexcel
Board Regular
- Joined
- Jun 16, 2010
- Messages
- 86
- Office Version
- 2016
- Platform
- MacOS
Hi,
I am trying to find a formula that will look up numbers of one worksheet and give me totals on another worksheet. The specifics:
Column A Column B Column C
Room # Class period The enrollment count
The catch is that some classrooms and periods are listed twice, as two different sections of students are combined into a single room during the same period. I need to know the total count of student bodies ("Warm body count") for each classroom for each period. Example from the worksheet called classLoad:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Classroom[/TD]
[TD]Period[/TD]
[TD]Total enrolled[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]1[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
On a separate sheet named perTotals, I have a grid and want a total of the warm body count for each classroom during each class period.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Classroom[/TD]
[TD]Per1[/TD]
[TD]Per2[/TD]
[TD]Per3[/TD]
[TD]Per4[/TD]
[TD]Per5[/TD]
[TD]Per6[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]38[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Etc.
I need a formula that will count all the entries for room A1 (column A), per. 1 (column B) found in column C, Total enrolled, from the worksheet called classLoad to return the sum in B2 in worksheet perTotals.
Any help is much appreciated.
Thanks,
Karen
I am trying to find a formula that will look up numbers of one worksheet and give me totals on another worksheet. The specifics:
Column A Column B Column C
Room # Class period The enrollment count
The catch is that some classrooms and periods are listed twice, as two different sections of students are combined into a single room during the same period. I need to know the total count of student bodies ("Warm body count") for each classroom for each period. Example from the worksheet called classLoad:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Classroom[/TD]
[TD]Period[/TD]
[TD]Total enrolled[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]1[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
On a separate sheet named perTotals, I have a grid and want a total of the warm body count for each classroom during each class period.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Classroom[/TD]
[TD]Per1[/TD]
[TD]Per2[/TD]
[TD]Per3[/TD]
[TD]Per4[/TD]
[TD]Per5[/TD]
[TD]Per6[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]38[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Etc.
I need a formula that will count all the entries for room A1 (column A), per. 1 (column B) found in column C, Total enrolled, from the worksheet called classLoad to return the sum in B2 in worksheet perTotals.
Any help is much appreciated.
Thanks,
Karen