ArielLeigh
New Member
- Joined
- Mar 13, 2019
- Messages
- 1
I'm having an issue with a pivot table giving me "#DIV/0!" because it is taking the average of a number and a blank cell. How can I have the pivot table take the average of desired values but ignore the blank cells?
<tbody>
</tbody>
This is an example of my data and my pivot table shows the program and average completion. Instead of taking the average of 40% and 85% North, it give me an error. HELP!
Team | Program | Completion |
NorthA | North | |
NorthB | North | 40% |
NorthC | North | 85% |
SouthA | South | 6% |
SouthB | South | 14% |
<tbody>
</tbody>
This is an example of my data and my pivot table shows the program and average completion. Instead of taking the average of 40% and 85% North, it give me an error. HELP!