cells with text or not !

fireslguk

Active Member
Joined
Nov 11, 2005
Messages
294
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 :eek:
 

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.
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")
 
Upvote 0
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 ?
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top