COUNTIF Function Provides Text Feedback, Not Values
 

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

COUNTIF Function Provides Text Feedback, Not Values
 

Please try

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

If this post helps click Yes
---------------
Jacob Skaria


"Michael S. Nelson" wrote:

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

COUNTIF Function Provides Text Feedback, Not Values
 

Oops.. Please check the cell format of D3:D18 and A18.
--
If this post helps click Yes
---------------
Jacob Skaria


"Michael S. Nelson" wrote:

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

COUNTIF Function Provides Text Feedback, Not Values
 

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

Mike

"Jacob Skaria" wrote:

Please try

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

If this post helps click Yes
---------------
Jacob Skaria


"Michael S. Nelson" wrote:

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

COUNTIF Function Provides Text Feedback, Not Values
 

Please refer this link

http://www.bettersolutions.com/excel...R446824542.htm

If this post helps click Yes
---------------
Jacob Skaria


"Michael S. Nelson" wrote:

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

Mike

"Jacob Skaria" wrote:

Please try

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

If this post helps click Yes
---------------
Jacob Skaria


"Michael S. Nelson" wrote:

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