ellaine216
New Member
- Joined
- Apr 29, 2017
- Messages
- 5
Hello, guys, I'm currently having the final assignment of my semester and I'm having difficulty when it comes to the part to adding up dashes as zeros.
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
There are two tables more which I have to use INDEX MATCH to look up the values and add them up, but the formula gives me the result when it comes to the cells including "-".
Please give me some ideas of how to solve this problem. Keep in mind that if I change the Park and Ticket type of any other days into to dashes and insert value in Thursday' cells, the formula should still working for it.
Thursday | Friday | Saturday | TOTAL | ||||
Park | Ticket Type | Park | Ticket Type | Park | Ticket Type | ||
Universal Studios | One Park - 1 Day | Universal Studios | Park to Park - 1 Day | Walt Disney World | Magic Kingdom - 1 Day | $624.00 | |
Universal Studios | One Park - 1 Day | Universal Studios | Park to Park - 1 Day | Walt Disney World | Park Hopper - 1 Day | $712.00 | |
Walt Disney World | Other - 1 Day | Universal Studios | Park to Park - 1 Day | Walt Disney World | Park Hopper - 1 Day | $707.20 | |
- | - | Universal Studios | Park to Park - 1 Day | Walt Disney World | Magic Kingdom - 1 Day | #N/A | |
- | - | Universal Studios | Park to Park - 1 Day | Walt Disney World | Park Hopper - 1 Day | #N/A |
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
There are two tables more which I have to use INDEX MATCH to look up the values and add them up, but the formula gives me the result when it comes to the cells including "-".
Please give me some ideas of how to solve this problem. Keep in mind that if I change the Park and Ticket type of any other days into to dashes and insert value in Thursday' cells, the formula should still working for it.