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 programm...
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.