Forum Discussion
Countif Formula Help
I am tracking employee errors on transactions for my organization and am trying to provide calculate how many times each error has occurred over a 12-month time frame. The error reasons are programmed into the employee tracking logs and I have compiled everyone's log. All of those logs have been compiled into one giant list (about 1300 entries). They went super granular when creating these tracking logs and there are 68 different "Error Reasons" - Below is an example of a handful of them.
Previously when I have done this, I have manually input CountIf formulas for each of the error codes, which is doable but very time consuming. Is there a way to get Excel to auto populate the error reasons?
2 Replies
Hi, reading your question, my recommendation is to create the Error Reason list and give each Error row as unique ID number. As you mentioned there are 68 different "Error Reasons". The reason for the Unique ID is that text is hard to count and an error is simply made and diffcult to recognise.
Create a table of the data and create a pivot tabel to count for each Error Reason. See screenshot below.Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
