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)
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
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)
Name | Total Points | 8/2/19 | 8/3/19 | 8/4/19 |
Bill | 3.00 | Early Out 0.5 | Absent 1.0 | NCNS 1.5 |
Cathy | 1.00 | Excused 0.0 | Early Out 0.5 | Early Out 0.5 |
Sally | 1.50 | Tardy 0.5 | Tardy 0.5 | Tardy 0.5 |
John | 2.00 | Vacation 0.0 | Absent 1.0 | > 50% shift worked 1.0 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>