I posted this to Excel formulas, but something tells me its more than that.

I have 1 sheet for every student. with a class code (PSY1, ENG2) in the
same cell in every worksheet. I'd like a summary sheet that shows for
period 1,
I have 3 PSY, 2 ENG, 5 HIST, etc.. i.e. a little pivot table.

Any ideas ?

Thanks

MK