I am using windows 7 with excel 2013.
I want to simplify my sheet by using sumif or some other function to add all values in cells that contain one letter and one number in row 6, column C-AM.
One cell may have V8 (for 8 vacation hours used) and some other cell may have S4 (for 4 sick hours used) and most will be blank. I then want to add up all the vacation hours, all the sick hours, and so on. The user can insert their own categories in column AS 15-19 and use that letter for the time, and that is where I want to get the criteria from.
<tbody>
</tbody>
I want to add up row 3.
I have a snip of the sheet, but I don't know how to add it.
Does this make sense? This is my first post here, so please bear with my amateurishness.
I want to simplify my sheet by using sumif or some other function to add all values in cells that contain one letter and one number in row 6, column C-AM.
One cell may have V8 (for 8 vacation hours used) and some other cell may have S4 (for 4 sick hours used) and most will be blank. I then want to add up all the vacation hours, all the sick hours, and so on. The user can insert their own categories in column AS 15-19 and use that letter for the time, and that is where I want to get the criteria from.
A | B | C | D | E | F | G | H | I | J | |
1 | S | M | T | W | T | F | S | S | M | T |
2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
3 | V8 | V8 | S4 | S8 |
<tbody>
</tbody>
I want to add up row 3.
I have a snip of the sheet, but I don't know how to add it.
Does this make sense? This is my first post here, so please bear with my amateurishness.