vlookup with sum

[jdgel817]

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

	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>

 

[steve the fish]

Try this maybe:

=IF(COUNT(E8:K8)=0,0,IFERROR(VLOOKUP(SUM(E8:K8),Scoring!$B$28:$C$33,2,0),0))