If someone can direct me to the correct place that would be great. I have Excel 2016. I posted elsewhere without a response so I don't know if that was because there's no answer, I was unclear, or because it was a pretty old post. I also searched posts & a few books with no success.
I'm trying to create a column that shows a percent of "date presented to Client" to "total #" for each employee
I have a count for each column (employee for their total clients, the total client info entered, the total reviewed, and total presented to client.)
I've done ='Date presented to Client'/'Total #' as the formula but end up with #DIV/0!. I want to end up with 3.448% (1/29) and 10.5%(4/38) for the two employees with presentations.
I've tried several things with the same result and my googling skills are apparently pretty poor since I've found nothing on this specifically. Any help or direction would be appreciated.
<tbody>
</tbody>
I'm trying to create a column that shows a percent of "date presented to Client" to "total #" for each employee
I have a count for each column (employee for their total clients, the total client info entered, the total reviewed, and total presented to client.)
I've done ='Date presented to Client'/'Total #' as the formula but end up with #DIV/0!. I want to end up with 3.448% (1/29) and 10.5%(4/38) for the two employees with presentations.
I've tried several things with the same result and my googling skills are apparently pretty poor since I've found nothing on this specifically. Any help or direction would be appreciated.
Count of Total # | Count of Data Loaded | Count of Date Reviewed | Count of Date presented to Client | Count of Field1 |
36 | 2 | #DIV/0! | ||
26 | 2 | #DIV/0! | ||
13 | 3 | #DIV/0! | ||
29 | 7 | 1 | 1 | #DIV/0! |
44 | 6 | #DIV/0! | ||
38 | 7 | 4 | 4 | #DIV/0! |
<tbody>
</tbody>