CODEWITHSUNDEEP
excelsumpivot-table
user2512863
user2512863

Reputation:

Search data by two variables, then sum associated values

I am working on a scheduling database that tracks the master schedule for all the classes, the student hours, and the hours teachers have worked. The problem I am running into is the final area of this workbook in Excel.

We want to show the teacher hours by each month (Jan, Feb, Mar, etc) and the name of the interpreter.

---------Jan---Feb---Mar---Apr---May---...
-Teach1
-Teach2
-Teach3

I want to pull this data from the master schedule which has three columns I will use:

---Date ---- Teacher Name --- Class Hours
 1/23/2013 -- Teach1-----------      1
10/10/2013 -- Teach2-----------      2
10/23/2013 -- Teach1-----------      4
10/23/2013 -- Teach1-----------      2

So, I am trying to pull a sum of the data for Teach1 for October.

Upvotes: 0

Views: 86

Answers (1)

pnuts
pnuts

Reputation: 59475

I suggest a PivotTable as shown:

enter image description here

where the dates are formatted mmm and Grouped by month.

Upvotes: 1

Related Questions