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]

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.

Try this...

Book1
	A	B	C	D	E
2	Katie	8	_	Katie	11
3	Anna	6	_	Anna	9
4	Jessica	5	_	Jessica	13
5	Katie	3	_	_	_
6	Anna	3	_	_	_
7	Jessica	8	_	_	_
Sheet1

This formula entered in E2 and copied down:

=SUMIF(A$2:A$7,D2,B$2:B$7)

 

[dannyodo]

Thank you - I will try it today. Danny.

 

[dannyodo]

Thank you. It is obviously more complicated than I thought. This is a better example of what I have.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:

Monday Aug 1
Katie 8
Anna 6
Jessica 5
Ashley OFF
Tuesday Aug 2
Katie 3
Anna 3
Jessica 8
Sarah OFF
Wed Aug 3
Anna 8
Katie 7
Jessica 4
Sarah 6
Edith OFF
I have the names in one cell and the number in an adjacent cell. But in a cell above, I havthe date and in a cell below I have a name with the adjacent cell showing that person is 'OFF".
I am sorry I am so stupid but at 62 I am trying to learn something I am not able for. I really appreciate what you do. Thank you. Danny.

 

[T. Valko]

Thank you. It is obviously more complicated than I thought. This is a better example of what I have.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:

Monday Aug 1
Katie 8
Anna 6
Jessica 5
Ashley OFF
Tuesday Aug 2
Katie 3
Anna 3
Jessica 8
Sarah OFF
Wed Aug 3
Anna 8
Katie 7
Jessica 4
Sarah 6
Edith OFF
I have the names in one cell and the number in an adjacent cell. But in a cell above, I havthe date and in a cell below I have a name with the adjacent cell showing that person is 'OFF".
I am sorry I am so stupid but at 62 I am trying to learn something I am not able for. I really appreciate what you do. Thank you. Danny.

It should still work.

Book1
	A	B	C	D	E
1	Monday Aug 1	_	_	Name	Total
2	Katie	8	_	Anna	17
3	Anna	6	_	Katie	18
4	Jessica	5	_	Jessica	17
5	Ashley	OFF	_	Sarah	6
6	Tuesday Aug 2	_	_	Edith	0
7	Katie	3	_	_	_
8	Anna	3	_	_	_
9	Jessica	8	_	_	_
10	Sarah	OFF	_	_	_
11	Wed Aug 3	_	_	_	_
12	Anna	8	_	_	_
13	Katie	7	_	_	_
14	Jessica	4	_	_	_
15	Sarah	6	_	_	_
16	Edith	OFF	_	_	_
Sheet1

Formula entered in E2 and copied down:

=SUMIF(A$2:A$16,D2,B$2:B$16)

 

[dannyodo]

Thank you again. I have checked my formula a dozen times and still cannot get the correct answers. This is the formula I entered. =SUMIF(B$2:B$46,P2,C$2:C$46) I presume the $ sign means the $ sign? Thank you for your patience with an old man.

 

[T. Valko]

Thank you again. I have checked my formula a dozen times and still cannot get the correct answers. This is the formula I entered. =SUMIF(B$2:B$46,P2,C$2:C$46) I presume the $ sign means the $ sign? Thank you for your patience with an old man.

The $ dollar sign means that when you drag copy the formula down a column the row references in the ranges B2:B46 and C2:C46 will not change. They will remain absolute.

Can you post a link to your file (or a representative sample file)?

You can use a free file host if need be.

 

[dannyodo]

Thank you for your patience. You have thrown me for a loop! Us Irish are a 'thick" people! I do not know how to do a link or a free file host! I'm sorry: i just am not that good at this. I do not mind sending you my file; it is nothing confidential. Let me know how to post the file, please. We are sweltering here in Charlotte, North Carolina. Again, my sincere thanks for your help and patience. Danny.

 

[T. Valko]

Thank you for your patience. You have thrown me for a loop! Us Irish are a 'thick" people! I do not know how to do a link or a free file host! I'm sorry: i just am not that good at this. I do not mind sending you my file; it is nothing confidential. Let me know how to post the file, please. We are sweltering here in Charlotte, North Carolina. Again, my sincere thanks for your help and patience. Danny.

Here's a free file host that I use sometimes.

http://tinyurl.com/24xfnt

 

[dannyodo]

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