Countifs Help

[Jose9Reyes]

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?

[Jose9Reyes]

Anyone?

[zbor]

Can you upload example workbook?

make sure to remove all private data.

[Jose9Reyes]

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?

[zbor]

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

[Jose9Reyes]

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.

[zbor]

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.