Microsoft Office Tutorials and References
In Depth Information
Exhibit 8.23 Analysis area of data collection
a service stock-out of 40 minutes, in which case the test results in a negative value
and, thus, the cell value Stkout . There may be more detailed analysis that is possible
for each stock-out. For example, is it possible to determine who will and will not
receive service?
In Exhibit 8.24, we see that cell BC254 counts the number of Engine/
electrical Diagnosis stock-outs, 6. This is done by using a simple COUNTIF()
function: COUNTIF(BC4:BC253,“Stkout”). We could easily count the number of
stock-out minutes in column BC rather than simply determining that a stock-out
Exhibit 8.24 Determination of clients not receiving service
Search JabSto ::




Custom Search