Hello,
I'm having some difficulty getting what I think should be a SUMIF formula to render the results I am looking for (if I am off with the SUMIF I'm up for any solution.)
In the example there are two tabs - one is ultimately a data dump and the other will be an individual's "dashboard"
On the Rollup/Dashboard tab I am ultimately trying to do the following:
1. In Column B -Total Holds: Count the # of documents processed by analyst per day (i.e. all documents completed 10/1/16 by Sally) Note: Each line entry is considered a single volume document
2. In Column C - Total errors: Count the total number of errors by analyst per day (Error types are Columned E-N on tab 1, however no matter how many X's are in a row it should register as a count of 1 as it is only 1 document it just had multiple errors)
For the example please assume tab 2 is for Sally only, not Mark.
Any help is appreciated!
Bookmarks