Here’s the situation:
I have three columns on the spreadsheet.
Column 1 = This has the initials of the analyst who is assigned responsibility for overseeing a report. (i.e. JJC is responsible for Report GK, JLL is responsible for Report LLR, etc)
Column 2 = The Intern (not the analyst) inserts his/her initials here as soon as the report enters our office. Otherwise, this cell(s) is blank.
Column 3 = The Analyst inserts his/her initials here as soon as he/she enters the report in the database. Otherwise, this cell(s) is blank.
Here’s what I need:
How many reports have entered our office by analyst (i.e. how many reports assigned to JJC have entered the office?).
How many reports assigned to said analyst have been entered into the database?
Eventually I will need these broken down into %, but that should be easy.
This is definitely a counting function issue, but I haven’t been able to get DCOUNTA or COUNTIF to do anything. Your help is much appreciated!
I have three columns on the spreadsheet.
Column 1 = This has the initials of the analyst who is assigned responsibility for overseeing a report. (i.e. JJC is responsible for Report GK, JLL is responsible for Report LLR, etc)
Column 2 = The Intern (not the analyst) inserts his/her initials here as soon as the report enters our office. Otherwise, this cell(s) is blank.
Column 3 = The Analyst inserts his/her initials here as soon as he/she enters the report in the database. Otherwise, this cell(s) is blank.
Here’s what I need:
How many reports have entered our office by analyst (i.e. how many reports assigned to JJC have entered the office?).
How many reports assigned to said analyst have been entered into the database?
Eventually I will need these broken down into %, but that should be easy.
This is definitely a counting function issue, but I haven’t been able to get DCOUNTA or COUNTIF to do anything. Your help is much appreciated!