VBA to Total column D based on name column A

[rspalding]

Hi and thanks for the help.​

I have a list of names in column A and numbers in column D. I want to total up the numbers in column D after the last entry in column A or D and add the word total next to it in column C. See below please

Alvarez	Ramiro	07/26/2024	8.000
Total​	8.00
Balzan	Mariana	07/26/2024	8.000
Total​	8.00
Cardoza	Rey	07/25/2024	13.250
Cardoza	Rey	07/26/2024	13.500
Cardoza	Rey	07/27/2024	13.250
Total​	40.00
Chavez	Jean	07/24/2024	8.000
Chavez	Jean	07/25/2024	8.000
Chavez	Jean	07/26/2024	8.000
Dominguez	Julio	07/25/2024	8.000
Dominguez	Julio	07/26/2024	8.000

 

[Jeffrey Mahoney]

Still trying to help. Can you edit the cell, copy what's inside and paste that here? Or take a screenshot of the formula bar when your cursor is on one of the total cells

 

[rspalding]

Jeff,

 

[Jeffrey Mahoney]

So, the link you're talking about, is that the green triangle next to each value? If so, it may be telling you that the cell is formatted as TEXT. You can change that to a number.

Easy way is to highlight the numbers, set the format to General or a number, then select DATA > Text to Columns > Finish.

 

[rspalding]

Hi Jeff,

So it works except its adding "Total" to the first line of each name and changing the hours to 0 but still calculating the correct total. I would also like to a grand total at the bottom of the all the name totals.

Alvarez	Ramiro		07/26/2024		8.00
				Total	8.0
Cardoza	Rey		07/25/2024	Total	0.0
Cardoza	Rey		07/26/2024		13.50
Cardoza	Rey		07/27/2024		13.25
				Total	40.0
Chavez	Jean		07/24/2024	Total	0.0
Chavez	Jean		07/25/2024		8.00
Chavez	Jean		07/26/2024		8.00
				Total	24.0
Dominguez	Julio		07/25/2024	Total	0.0
Dominguez	Julio		07/26/2024		8.00
				Total	16.0

Thanks,

Robert