Trying to add values from cells with a related name in the adjoining cell.

[dannyodo]

I have a simple scheduling spreadsheet for 5 employees. I want the sheet to add the hours for each person and give me a total.the cells are like this:

Katie 8
Anna 6
Jessica 5
Katie 3
Anna 3
Jessica 8
I have the names in one cell and the number in an adjacent cell. Please, please help me.

 

[T. Valko]

http://cjoint.com/?AGzeeYZdI9l
I hope this is correct and thank you again. Danny.

Ok, the problem is that some of your data has extraneous spaces at the end. Like this:

Katie[space]

I removed all those spaces and the sum works just fine.

It can be a lot of work trying to clean data of unwanted spaces. Luckily a smart chap made it easy for us.

The macro at this website will remove all leading/trailing and multiple interspersed char 32 space characters. It will also remove and/or convert char 160 non breaking spaces into standard char 32 space characters. It will work on text or numbers and the numbers will be converted to true numeric numbers.

I use this macro dozens of times every single day! It's a real time saver.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Here's your file with all the spaces removed and the formula entered in column A:

http://cjoint.com/?AGzeFvPhnBn

 

[dannyodo]

Thank you so much. I have learned a lot. I really appreciate your help, especially over a weekend. This is a wonderful invaluable service to a small business. Danny.

 

[T. Valko]

Thank you so much. I have learned a lot. I really appreciate your help, especially over a weekend. This is a wonderful invaluable service to a small business. Danny.

You're welcome. Thanks for the feedback!