Sum using right or left function

[sneaky911]

I have a simple attendance tracking spreadsheet. Data validation is set up to select the "violation" from a list. The violation also has a point total attached to it. Example: Call off 1.0, Early out 0.5, NCNS 3.0, etc. How can I sum a range using the "Right" function? I'm only interested in the values 1.0, 0.5, 3.0 etc.

I can get it to calculate if I do each cell individually:
=SUM(RIGHT(C3,3),RIGHT(D3,3),RIGHT(E3,3))

How can I simply highlight the entire date range and use the RIGHT function to calculate the point values? (Columns C-E)

[TABLE="width: 554"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Total Points[/TD]
[TD]8/2/19[/TD]
[TD]8/3/19[/TD]
[TD]8/4/19[/TD]
[/TR]
[TR]
[TD]Bill[/TD]
[TD]3.00[/TD]
[TD]Early Out 0.5[/TD]
[TD]Absent 1.0[/TD]
[TD]NCNS 1.5[/TD]
[/TR]
[TR]
[TD]Cathy[/TD]
[TD]1.00[/TD]
[TD]Excused 0.0[/TD]
[TD]Early Out 0.5[/TD]
[TD]Early Out 0.5[/TD]
[/TR]
[TR]
[TD]Sally[/TD]
[TD]1.50[/TD]
[TD]Tardy 0.5[/TD]
[TD]Tardy 0.5[/TD]
[TD]Tardy 0.5[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]2.00[/TD]
[TD]Vacation 0.0[/TD]
[TD]Absent 1.0[/TD]
[TD]> 50% shift worked 1.0[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about
=SUMPRODUCT(--(RIGHT(C2:E2,3)))

 

[joeu2004]

Try:

=SUMPRODUCT(--RIGHT(C3:E3,3))

PS.... Just saw Fluff's similar response. There is no need for, nor benefit to, putting an extra set of parentheses around RIGHT(C3:E3,3).

 

[sneaky911]

Works perfectly! Thank you both.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[sneaky911]

Need help with one more thing. I've modified your formula a bit. It works as expected with one exception...I need to include something that will avoid throwing an error if there's a blank cell in the range. I've tried a few different things all producing different results. Just to clarify the blank cell would be in E3:NX3.

=SUMPRODUCT(--(INT($E$2:$NX$2>TODAY()-365)),--(RIGHT(E3:NX3,3)))