# cells with text or not !

#### fireslguk

##### Active Member
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

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Care to take another crack at stating the desired results?

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")

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 ?

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

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

cheers buddy wicked !!

Replies
3
Views
645
Replies
6
Views
413
Replies
3
Views
842
Replies
6
Views
253
Replies
6
Views
974

1,214,753
Messages
6,121,318
Members
449,026
Latest member
Nireeksha Shetty

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back