cells with text or not !

[fireslguk]

hi there folks,

I would like the following to happen in colum c

....A............B..............C...................D..................................E
1...CAR.......blank........ERROR...........error if col c = error........ no of them
2...CAR.......BLUE.........=blank CELL
3................RED..........ERROR
4...blank.....blank........=blank


however instead of cars and colours can be any text not percific

then next formula to then read this column c for error and if there are state error in cell D and no of them in E otherwise both d and e blank.

(its to make sure if 1 cell has text so does the other and if both cells blank not problem)

this wont be hard im sure

 

[just_jon]

Care to take another crack at stating the desired results?

 

[RalphA]

Here's one solution:

In D1, enter =IF(C1="ERROR",C1,"") and copy down.
In E1, enter =COUNTIF(D1:D30,"ERROR")

Note that, if you don't need colmn D, you could simply enter the this formula whereever, and it would do the required counting:

=COUNIF(b1:b30,"ERROR")

 

[fireslguk]

i want cell in column c to look at text in same row column a and b and if both are blank or both contain text ignore but if text in 1 of them then error appears in this column c , a cell in column d is just to look at column c and if finds errors state error and column e to have total of the errors


its to check data entry and make sure cells arent being left out


am i restricted to 2 cells or can i adjust to 3 or 4 ?

 

[just_jon]

Book1.xls
	A	B	C	D	E
1	blah		ERROR	ERROR	1
2	blah	blah
3			ERROR	ERROR	2
4		blah	ERROR	ERROR	1
5	blah	blah
6
Sheet4

Is this it?

 

[fireslguk]

almost dude, but i dont want error to come up if both columns blank

 

[fireslguk]

lets say someone puts car in one cell and puts the colour red in another same row thats ok, lets say they forget to put the colour then that is an error or they put the colour and forgot to put car = again error, however blank cells = no error because they havent put any thing in yet

am i still confusing

 

[just_jon]

almost dude, but i dont want error to come up if both columns blank

Book1.xls
	A	B	C	D	E	F
1	blah			ERROR	ERROR	2
2	blah	blah	blah
3
4		blah		ERROR	ERROR	2
5	blah	blah		ERROR	ERROR	1
6
Sheet4

 

[fireslguk]

cheers buddy wicked !!