Doug Mutzig
Board Regular
- Joined
- Jan 1, 2019
- Messages
- 57
- Office Version
- 365
- Platform
- Windows
Good morning all!
I have a table with the following columns: Staff Name, Date IN, Hours Earned, Earned Comments, Current Total Earned.
When staff are called in or work extra hours they are entered into the table so the Staff Name column will have staff listed multiple times.
what I am trying to do is have a running total for Hours earned so that when they start a new row for a staff member and enter in hours earned it is added to the total and displayed in the current total earned column.
Example
Staff Name Date In Hours Earned Current Total
Example, Ann 1/5/2019 5 5
Examp, Dan 1/7/2019 3 3
Example, Ann 1/10/2019 8 13
Example, Ann 1/15/2019 2 15
Example, Dan 1/15/2019 7 10
I have been trying a SUMIF but I am not sure how to do the criteria portion. The Range is [@[Staff Name]], and the sum range is [@[Hours Earned]]. I am just not sure how to put in "look for duplicates of the name" for the criteria.
Is SUMIF the correct function to be using? and how can I frame the criteria portion correctly?
Thank you for any help and guidance you can give on this!
I have a table with the following columns: Staff Name, Date IN, Hours Earned, Earned Comments, Current Total Earned.
When staff are called in or work extra hours they are entered into the table so the Staff Name column will have staff listed multiple times.
what I am trying to do is have a running total for Hours earned so that when they start a new row for a staff member and enter in hours earned it is added to the total and displayed in the current total earned column.
Example
Staff Name Date In Hours Earned Current Total
Example, Ann 1/5/2019 5 5
Examp, Dan 1/7/2019 3 3
Example, Ann 1/10/2019 8 13
Example, Ann 1/15/2019 2 15
Example, Dan 1/15/2019 7 10
I have been trying a SUMIF but I am not sure how to do the criteria portion. The Range is [@[Staff Name]], and the sum range is [@[Hours Earned]]. I am just not sure how to put in "look for duplicates of the name" for the criteria.
Is SUMIF the correct function to be using? and how can I frame the criteria portion correctly?
Thank you for any help and guidance you can give on this!