Formula Help Plz

[EVANS8773]

Greetings all, i am the forumla for the attached screenshot. In the yellow boxs is the total goals scoredd in a game of football. Directly above is what a player has predicted. As you can see in my example the total goals was predicted 7 times. The formula i need is a sumif ? that counts the correct goals and awards 1 point. So player 30 scores 7 points (not the 6 i have in this screenshot. I think i know basics like =sumif( a1=b1,1,0) but how to do a whole line i dont know....Just noticed game 1 is wrong score lol....but you get my drift


Hope someone can help

Cheers

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
34		1	2	3	1	4	3	2	1	2	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6	6
35
36		2	3	2	1	4	3	2	1	2	3	1	2	3	1	3	2	2	2	2	2	2	2	2	2	5	2	2	2	2	2
Sheet6

Cell Formulas
Range	Formula
AF34	AF34	=SUMPRODUCT(--(B34:AE34=B36:AE36))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B36:AE36	Expression	=B36=B34	text	NO