COUNTIF Function not Working - Formatting Issue

[ahauswa]

Hi,

I've been trying to figure this one out for a while now. I have a list of survey results that update from a query. So each time I update it, the list gets longer with newer submisssions.

I have a seperate table calculating percentages, average scores, etc...for each question (about 20 of them). three calculations are countifs functions to know how many were 9 or 10s, 7 or 8s, or between 0 and 6.

Now here is the problem, when I refresh the data all the calculations work except for 1 question ! All the countifs work except for the first question. I tried copying and pasting as values the results for that question but it still doesn't work. The results are formatted as general numbers so the issue is not there. The countifs for Question 1 all return 0s, but the countifs for the other questions return the right numbers.

What else could I check to try to make the countifs functions work on that particular column?

Thanks for the help,

Adrien

 

[Jonmo1]

The results are formatted as general numbers so the issue is not there.

Just because a cell is formatted as general does not necessarily mean the value in the cell is a number....
It may still be a "number stored as text"

Use ISNUMBER to verify

=ISNUMBER(A1)

Where A1 is a cell in question.

Does it return True or False?