Countif problem - very weird

I have been given a spreadsheet for me to fix as a countif function wasn't working and it has me baffled!!

Countif usually just works, it is very simple.

All that is happening on the sheet is a countif running down a whole column on another sheet in the workbook and counting the relevant data

=COUNTIF(Q000!$AH:$AH,Data!J1&"Y")

The formula above counts the word "sepy"

There are only 6 instances or sepy in the column but it gives the answer of 5!!

The problem is just in one cell on the Q000 sheet (cell AH204)

Its not counting "sepy" in that cell.

Why? You tell me!!

I have removed formatting from the cell, done Edit > Clear > All and then put the value back in but still nothing

Any help on this would be great

Without seeing the sheet it would be hard to tell why.

A common error which I have come across with countif is maybe with your word - sepy - there is a space before/after the word.

Nooooooooooooooooooooooo!!!!

I checked the month (Oct, Sep, etc) but not the Y's.

Why would someone do that??

Damn end users!!!

Many Thanks Guys for the swift turnaround

Just as i expected!!