W
WBromberek
How can I get the 'Total Hours' at the bottom of Column "B" to move down a row
each time I add another 'Employee Name' & 'Hours' in the next row. I also want
the 'Total Hours' to update with the added hours.
I currently have the formula: =Subtotal(9,B3:B9) in cell "B10".
Any help will be welcome. This is an example for the worksheet.
A B
Employee Name Hours
Fredrick Beauregard 8.00
Katie Mae Jones 2.00
Theodore Raymond 5.00
Samantha Jeans 4.00
Mike Marshall 2.00
Rick Danger 4.00
25.00
Thanks,
Bill E-mail to: (e-mail address removed)
each time I add another 'Employee Name' & 'Hours' in the next row. I also want
the 'Total Hours' to update with the added hours.
I currently have the formula: =Subtotal(9,B3:B9) in cell "B10".
Any help will be welcome. This is an example for the worksheet.
A B
Employee Name Hours
Fredrick Beauregard 8.00
Katie Mae Jones 2.00
Theodore Raymond 5.00
Samantha Jeans 4.00
Mike Marshall 2.00
Rick Danger 4.00
25.00
Thanks,
Bill E-mail to: (e-mail address removed)