Microsoft Office Forums - View Single Post - Compound Countifs Query not working

Thread: Compound Countifs Query not working

View Single Post

Old

06-28-2013, 10:27 AM

Lonercom

Lonercom is offline

Lonercom uses Windows XP

Windows XP Lonercom uses Office 2007

Lonercom uses Office 2007

Office 2007

Novice

The original poster

Join Date: Jun 2013

Posts: 6

Lonercom is on a distinguished road

Default

Resolved!

Changed the time call to =HOUR(C2)
so the query is =COUNTIFS(Time,0,HFC!B:B,A311,HFC!F:F,"Outage")
Kind of a PITA to change the query fro each day and hour but it's working. Thanks for the help.

Reply With Quote