Excel Count If Formula Question

Jan 9, 2018
Reaction score
I am making a workbook containing a summary worksheet for other worksheets for each month in the same workbook. In the summary worksheet I am using the COUNTIF formula to tally the occurrences of dropdown items on the other worksheets. A dropdown selection uses the < symbol (I formatted the cells on the worksheets as text). So when I enter the COUNTIF formula in my summary sheet, i.e., =COUNTIF(JAN!$E$2:$E$30,"< 37 wks") the tally is wrong. I'm not sure if the counting is getting thrown off because of the < symbol in my dropdown text. If so, how do I get Excel to NOT read < as a symbol?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question