Subtotal vs calculate vs sumif ???

C

CaroleO

Excel 2003, SR 1

I have a timesheet database, showing employee's name (Col C), clockin, clock
out on each line, with hours worked (Column L) in Decimal format and Subtotal
(Column M).

I need a formula in Column M that will give a running subtotal of L until
the employee's name changes. I have tried subtotal, sumif, sumproduct -
nothing seems to give me the results I need.

TIA,

CaroleO
 
C

CaroleO

Hi, Dave -

I changed the L1 to M1, and it works perfectly!

Thanks so much for your help!!

CaroleO
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtotal with sumif nested 1
SumProduct or sumif 4
SUMIF over multiple spreadsheets 4
Calculating subtotals 0
Macro Pause to Select range then Subtotal 0
Calculating subtotals 22
SUMIFS question 3
Combining SUMIF and SUBTOTAL 4

Top