Predict A Score Part II

[Russ At Index]

Hi Guys

The forumla works fine for every player but if you look at cell
R4 it shoul read as a total of 4 ( Actual 3-0 , Predicted 3-0 )
But the total for that cell =1

It does appear to be ok in cells K4 & V4 !!!!!!!!

Any ideas ??

thanks in advance

predict a score.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1			ActualScore		Philip		Philip		Brian		Brian		Russ		Russ	Tim		Tim		Andy		Andy
2			H	A	Prediction		Points		Prediction		Points		Prediction		Points	Prediction		Points		Prediction		Points
3	Tottenham	A	0	2	1	3	1		0	1	1		1	2	1	1	1	0		0	2	4
4	Portsmouth	H	3	0	4	0	1		3	0	4		2	0	1	3	0	1		3	0	4
5	Blackburn	A			0	2	0		1	2	0		1	1	1	0	2	0		0	3	0
Calc Sheet

 

[fairwinds]

Hi,

Better stick to one thread.

As the formula seems correct and the other cells give correct results I would check P4 and Q4. Are any of those numbers text formatted or have spaces in the cells or does any of them have decimals that are formatted not to show?