Total Snags: =COUNTA(A:A)-1 Open Snags: =COUNTIF(F:F,"Open") High Priority Open: =COUNTIFS(E:E,"High",F:F,"Open") Completed: =COUNTIF(F:F,"Fixed") On-Time Fix Rate: =Completed / Total Fixed If you paste the following into Excel (starting at A1), it will set up your headers and sample data: