Name | Day 1 | Day 2 | Average data (if there does not exist data for both days, use 1) | |||
Kevin | Durant | Kevin Durant | #N/A | 41.6 | ?? | |
LeBron | James | LeBron James | #N/A | 56.6 | ?? | |
Kevin | Love | Kevin Love | #N/A | 47.5 | ?? | |
Chris | Paul | Chris Paul | 42.3 | #N/A | ?? | |
Carmelo | Anthony | Carmelo Anthony | #N/A | 38.3 | ||
John | Wall | John Wall | 54.7 | 41.4 |
<colgroup><col span="2"><col><col span="4"></colgroup><tbody>
</tbody>
So here's the problem. This is a section of my 6000 entry excel file. In the Day 1 column, I have the point total for some point weighing system. If there's an N/A it means they didn't play on day 1. In Day 2 column, there's the point total for some point weighing system (these are like fantasy points). In the average column, I want to compute the average IF both days there exists fantasy points. If there's only points for Day 1 or Day 2, then I want to use that day's point total and don't average it. How do I do this?