Countifs Help

Hi guys,

I have a problem that I am struggling to solve. I have a table which is imported through Microsoft Query and refreshes every 5 minutes. The table is a list of service calls for a company. What I need to do is find the service calls with priortiy 1 which were attended to before their dead line. Below is a small example of the table and what code Im using.

Please Login or Register  to view this content.

=COUNTIFS(Table_Operations_Query[CallActionNumber], "1", Table_Operations_Query[Priority], "1", Table_Operations_Query[ResponseDeadlineTime], ">"& Table_Operations_Query[StartedTime])

The formula above should return the value 2 as it should pick up records which is the 1st and last one. This is a more simplied version of my table but the code doesnt seem to work and returns the incorrect values.:/

Has anyone got any ideas on how I could overcome it?

Anyone?

Can you upload example workbook?

make sure to remove all private data.

I dont believe this. That example I gave in the opening post I have just stuck into a new work book and it works perfectly? Could it be an issue with the data that is coming from our database into excel?

Looked like it should work so I asked you for workbook.
Check is Workbook calculation set to Automatic.

http://www.mediafire.com/?k7z552qf0tqiei0

I got it wrong, it didnt actually work. I've uploaded the workbook. Also ensured that Workbook Calculation is set to Automatic.

Looking a bit closer at it when I export the data from our database program it is in Time format. However when it goes into Excel it adds on the Date and Time i.e (16/02/2012 16:00:00). I have tried to custom format it to just show the time but the data is constantly there.

Thanks for your help.

Rather upload file on the forum than external site.

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.