I am trying to do a scorecard based on number of drinks consumed per week. Drinks consumed are entered daily the Week Total would keep a running point total. As drinks are consumed the total points would decrease. I was using a vlookup with a sum shown below:
=IFERROR(VLOOKUP(SUM(E8:K8),Scoring!B28:C34,2,FALSE),"0")
Here is the problem--with this formula the Week Total always starts with a 7 (i.e.sum of E8:K8 is recognized as zero and returns 7 points). How do I keep the same logic, but start the Week Total showing blank or zero?
Mon through Sun are cells E8:K8
<tbody>
</tbody>
Scoring Worksheet
<tbody>
</tbody>
=IFERROR(VLOOKUP(SUM(E8:K8),Scoring!B28:C34,2,FALSE),"0")
Here is the problem--with this formula the Week Total always starts with a 7 (i.e.sum of E8:K8 is recognized as zero and returns 7 points). How do I keep the same logic, but start the Week Total showing blank or zero?
Mon through Sun are cells E8:K8
Mon | Tues | Wed | Thur | Fri | Sat | Sun | Week Total | |
# of drinks |
<tbody>
</tbody>
Scoring Worksheet
# of Drinks | Points Earned |
0 | 7 |
1 | 6 |
2 | 4 |
3 | 3 |
4 | 2 |
5 | 1 |
>5 | 0 |
<tbody>
</tbody>