Good evening.

I am creating our school's master schedule that uses two worksheets, one for
first semester and one for second semester. My third worksheet is to analyze
how many times a particular 4-digit course code appears period-by-period,
i.e. 1220 = English 9.

For each class (from rows 3-83) and each period (columns C-K), I am using a
formula similar to: =COUNTIF('Semester 1'!$D$3:$D$83,A18) where A* refers to
the course code that's listed on the analysis page.

My question is this...the formula seems to work very well if I hand enter
the name of the course, for instance =COUNTIF('Semester
1'!$D$3:$D$83,"Lunch") works very well, but none of the other courses will
work.

Thank you for your feedback. If you would like a copy of the spreadsheet,
feel freely to email me at .

Enjoy your day.

Mike