If countIf formula error

[drop05]

Hello I am trying to see why this formula is printing out and how i should edit it? If there word description or if it is blank on the first column it should bring up the error, but if there is not the word description or empty and has like i have other 1, then the second-third-fourth-fifth column should have a value for that row

But if it it does have "Description" it can have but the values have to be blank on the 2nd-5th column
i was using this formula
=IF((COUNTIF(D51:D70,"<>Description*")+20)<>COUNTIF(E51:H70,"<>"&""),"New Desc, no amount","OK")

i have this formula for the second column and works if i have other in the first column and a value in the second and third, but if i place a value in the 4th column it gives an error
=IF((COUNTIF(D51:D70,"<>Description*")+20)<>COUNTIF(E51:H70,"<>"&""),"New Desc, no amt","OK")

so to better explain, if it has the word description in column 1 (D) then the 2nd-5th (E-H) column should not have values, if it doesnt have the word description but has the word other or something then 2nd-5th (E-H) must have values if not it gives the "New Desc, no amt" if it meets the requirements then "OK"

 

[etaf]

Ok, an image is difficult to see - see below for how to post a sheet here
anyway

=((COUNTIF(D51:D70,"<>Description*")+20))
This will count the number of cells that do not have a word starting with Description

And this
=COUNTIF(E51:H70,"<>"&"")
counts none blank cells in the range E51 to E70

so to better explain, if it has the word description in column 1 (D) then the 2nd-5th (E-H) column should not have values, if it doesnt have the word description but has the word other or something then 2nd-5th (E-H) must have values if not it gives the "New Desc, no amt" if it meets the requirements then "OK"

does this work , its a bit of clunky formula
=IF(D51="","",IF(OR(AND(((ISERROR(SEARCH("description*",D51,1)))),SUM(E51:H51)>0),AND((NOT(ISERROR(SEARCH("description*",D51,1)))),SUM(E51:H51)=0)),"OK","New Desc, No Amount"))
which would be OK

But its checking for the value of Description *
NOT(ISERROR(SEARCH("description*",D51,1)))
AND there is a NO value in E to F
SUM(E51:H51)=0)),
OR
NO Description
(ISERROR(SEARCH("description*",D51,1))))
AND
alue in E to F
SUM(E51:H51)>0
if either are TRUE , then OK
otherwise show "New Desc, No Amount"

If D does not contain any value - blank then leave blank
=IF(D51="","",


Not sure if you want just 1 entry to flag, this needs to be copied down to show the error

Various.xlsx
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
50												DESC
51				1								FALSE	TRUE	TRUE
52	description			1					New Desc, No Amount			FALSE	FALSE	FALSE
53	Name		4						OK			FALSE	TRUE	TRUE
54	DescriptionFred								OK			TRUE	FALSE	TRUE
55												FALSE	FALSE	FALSE
56	Name								New Desc, No Amount			FALSE	FALSE	FALSE
57	othername			1					OK			FALSE	TRUE	TRUE
58	New Name			1					OK			FALSE	TRUE	TRUE
59												FALSE	FALSE	FALSE
60	description x								OK			TRUE	FALSE	TRUE
61
62
Sheet12

Cell Formulas
Range	Formula
O51:O60	O51	=AND((NOT(ISERROR(SEARCH("description*",D51,1)))),SUM(E51:H51)=0)
P51:P60	P51	=AND(((ISERROR(SEARCH("description*",D51,1)))),SUM(E51:H51)>0)
Q51:Q60	Q51	=OR(AND(((ISERROR(SEARCH("description*",D51,1)))),SUM(E51:H51)>0),AND((NOT(ISERROR(SEARCH("description*",D51,1)))),SUM(E51:H51)=0))
L51:L60	L51	=IF(D51="","",IF(OR(AND(((ISERROR(SEARCH("description*",D51,1)))),SUM(E51:H51)>0),AND((NOT(ISERROR(SEARCH("description*",D51,1)))),SUM(E51:H51)=0)),"OK","New Desc, No Amount"))