Data validation.

[winds]

Hello. So today I want a pop-up error that comes out if say column K does not equal column D. Also, column E, G, I and J will have values inputted (except 0) so that column K is the total of column E, G, I and J, AND column K must equal to column D. If however, column K does not equal to column D, then a pop-up error must come out requiring to check the values in column E, G, I and J. I think data validation is in order but I can't seem to find a way to do it. Any ideas?

 

[StephenCrump]

It's not really a job for data validation. There are several alternatives. Here's one:

	A	B	C	D	E	F	G	H	I	J	K
1										ErrorCount	1
2
3				26	3		5		7	11	26
4				72	13		17		19	23	72
5				72	13		17		91	23	Error
6				10	1		2		3	4	10
7
Sheet1

Cell Formulas
Range	Formula
K1	K1	=COUNTIF(K3:K6,"Error")
K3:K6	K3	=IF(SUM(E3,G3,I3:J3)=D3,D3,"Error")

 

[winds]

Ok I got the idea, thank you very much!