COUNTIF Function Provides Text Feedback, Not Values

[Michael S. Nelson]

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 (e-mail address removed).

Enjoy your day.

Mike

 

[Jacob Skaria]

Please try

=COUNTIF('Semester 1'!$D$3:$D$83, "*" & Trim(A18) & "*")

If this post helps click Yes

 

[Jacob Skaria]

Oops.. Please check the cell format of D318 and A18.

 

[Michael S. Nelson]

Thank you, it works perfectly. However, now I need to brusu up on the trim
function. I appreciate your collaboration.

Mike

 

[Jacob Skaria]

Please refer this link

http://www.bettersolutions.com/excel/EDH113/LR446824542.htm

If this post helps click Yes