Formula help for newbie

[Darren1593]

Hi, i am trying to create a simple spreadsheet to track my team goalscorers, all i want is for the formula to notice a player name on one sheet and count the amount of goals he has scored on another sheet.

The first sheet has the player name in column D and the amount of goals scored in that game column E

The second sheet has the player name in column B and the Total goals scored column in C

Hope this makes sense and thanks for your help in advance

 

[Peter_SSs]

Welcome to the MrExcel board!

Something like this?

Excel Workbook
	D	E
1	Name	Goals
2	Player 1	0
3	Player 2	1
4	Player 1	2
5	Player 4	1
6	Player 3	2
7	Player 3	3
8	Player 2	1
9
10
Goals

Excel Workbook
	B	C
1	Name	Goals
2	Player 1	2
3	Player 2	2
4	Player 3	5
5	Player 4	1
6
Totals

 

[Darren1593]

This is sheet 1, with names and how many goals were scored.

https://share.icloud.com/photos/0Ium6uGoLgFarQMdL2snw_e0Q

This is sheet 2 where i would like i to look for the name of a player every week if they score when i add a new game each week we have played and tally it up. Is this possible?

https://share.icloud.com/photos/0jlpKkFAW-mD7X68sfLzlPTtg

hope this isn’t confusing

 

[Peter_SSs]

Unfortunately your Sheet2 does not show what the expected results are based on the data in Sheet1. However, it seems to me that the formula I suggested already is what you need, only adjusting for the different sheet names and ranges. Did you try it?

Does this not give you what you want if you put it in cell C2 of Sheet2 and copy it down?

=SUMIF(Sheet1!D$2:D$100,B2,Sheet1!E$2:E$100)

If not then please provide the expected results for your sample data with any further clarification you can give.

BTW, it would be more helpful if you post any sample data in small copyable screen shots directly in your post like I did in my last post. That way helpers can copy the sample data to their worksheets to test. Unfortunately we cannot copy it from images like you have provided.
My signature block below has a link for several ways to do that. Test them in the Test Here forum. That way, if something goes wrong, you won’t be messing up a main forum.

 

[Darren1593]

Thanks very much, works perfectly ??

Unfortunately your Sheet2 does not show what the expected results are based on the data in Sheet1. However, it seems to me that the formula I suggested already is what you need, only adjusting for the different sheet names and ranges. Did you try it?

Does this not give you what you want if you put it in cell C2 of Sheet2 and copy it down?

=SUMIF(Sheet1!D$2:D$100,B2,Sheet1!E$2:E$100)

If not then please provide the expected results for your sample data with any further clarification you can give.

BTW, it would be more helpful if you post any sample data in small copyable screen shots directly in your post like I did in my last post. That way helpers can copy the sample data to their worksheets to test. Unfortunately we cannot copy it from images like you have provided.
My signature block below has a link for several ways to do that. Test them in the Test Here forum. That way, if something goes wrong, you won’t be messing up a main forum.

 

[Peter_SSs]

Thanks very much, works perfectly

You're welcome.