istext formula

[Raggedyman]

I'm looking for help with the following istext formula;

When data is added to cells B1 and B2, I would like cell C1(=IF(istext(B1),20,"")) and this works.
I'm not sure of the formula to add another 20 to B2 when text is entered.
Thank you in advance

 

[Raggedyman]

Book1
	K
31
Marks

Cell Formulas
Range	Formula
P2:P6	P2	=SUM(D2:O2)
Q2	Q2	=SUMIF(D2:O2,MIN(D2:P2))
Q3:Q6	Q3	=SUMIF(D3:O3,MIN(D3))
D8:L8	D8	=IF(COUNTIF(D2:D7,MIN(D2:D7))=1,MIN(D2:D7)," ")
M8:O8	M8	=IF(COUNTIF(M2:M6,MIN(M2:M6))=1,MIN(M2:M6)," ")
Q8	Q8	=COUNT(D8:O8)

 

[Raggedyman]

I looking to have the Marks column (Q) total highlighted cells in each row not the number that is currently being displayed

 

[Raggedyman]

\

 

[Fluff]

Can you please repost your data,, but this time select A1:Q8 & then run XL2BB

 

[Raggedyman]

Book1
	A	B		D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		Month		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Tot	Marks
2	1	Jim		5	10	14										29
3	2	Jane		8	3	22										33	8
4	3	Nancy		10	15	7										32	10
5	4	Joe		16	7	31										54	16
6	5	April		20	9	18										47	20
8				5	3	7											3
Marks

Cell Formulas
Range	Formula
P2, P3:P6	P2	=SUM(D2:O2)
Q3:Q6	Q3	=SUMIF(D3:O3,MIN(D3))
D8:L8	D8	=IF(COUNTIF(D2:D7,MIN(D2:D7))=1,MIN(D2:D7)," ")
M8:O8	M8	=IF(COUNTIF(M2:M6,MIN(M2:M6))=1,MIN(M2:M6)," ")
Q8	Q8	=COUNT(D8:O8)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:O6	Cell Value	=C$8	text	NO
B3	Cell	contains a blank value	text	NO
B2	Cell	contains a blank value	text	NO

 

[Raggedyman]

Book1
	A	B		D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		Month		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Tot	Marks
2	1	Jim		5	10	14	10									39
3	2	Jane		8	3	22	11									44	8
4	3	Nancy		10	15	7	12									44	10
5	4	Joe		16	7	31	13									67	16
6	5	April		20	9	18	14									61	20
Marks

Cell Formulas
Range	Formula
P2, P3:P6	P2	=SUM(D2:O2)
Q3:Q6	Q3	=SUMIF(D3:O3,MIN(D3))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:O6	Cell Value	=C$8	text	NO
B3	Cell	contains a blank value	text	NO
B2	Cell	contains a blank value	text	NO

 

[Raggedyman]

Looking to add total highlighted cells in rows 2:6. Cell Q2 should total 2 highlighted cells

 

[Fluff]

I'm sorry, but this has absolutely nothing to do with your op, therefore you will need to start a new thread.
Thanks