FALSE output from table formulae

I have an excel table which produces stats on individuals.

One of the formulae is

=IF(OR(tblIncidentData[@State]="Closed",tblIncidentData[@State]="Resolved"),COUNTIFS(tblIncidentData[Assignee], "="&[@Analyst], tblIncidentData[Resolved D&T], ">="&$D$2, tblIncidentData[Resolved D&T], "<="&$F$2, tblIncidentData[_Chargeable],"=Chargeable"))

Where @Analyst contains the individuals name.

So I have 8 rows that it works perfectly on and reports a number, I then have one row, with exactly the same formulae, which has FALSE and I have no idea why, what i do no is

i) If i use the analyst name on the row below, it works fine
ii) The cell is formatted exactly the same
iii) If i put someone elses name in there, I get the same error.
iv) I've deleted the row from the table, which obviously causes the one below to move up, and that then produces a FALSE.

Thanks Special K, so what is the better way to do this then? Why does this work for other people on the list? why does it work for this one individual if I put him on another row, as per the example in my initial post?

Do you mean just the worksheet that has the table on it, or also the data that sits behind it? If it's the data that would take quite a bit of sensitising

If i put that analyst name on a different row of the table, then i do not get a false, i get the figure I expect - 93.

On this row of the table, regardless of the analyst name i use, it always give a FALSE. I can use the same analyst name on the row above or below that line and i get the figures i would expect for them.

So I can't see it is the data.

Sorry, what do you mean the state column for that row? State is a column within the datasheet, the query is looking for any records that have a STATE of either Resolved or Closed, between two dates and is Assigned to @Analyst in the table.

XInitwit - the state column is on the datasheet which is seperate to the sheet this table is in. Across the whole datasheet, in the state column, not only is there resolved or closed but also Open, In Progress etc.

I get the point that the OR statement doesn't say what to do if it is not resolved or closed

What i don't get is
a) Why the exact same query does not fail on the other rows of my table whether I use the name of the individual that is shown against the FALSE originally, or anyone elses name. The formulae used on that row of my table fails regardless of the individual name used,

Also if I recreate the table, anywhere else on the worksheet, it works fine.