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

 

[Fluff]

Hi & welcome to MrExcel
How about
=SUM(--ISTEXT(B1:B2))*20

 

[Raggedyman]

Thank you for your help it worked.

 

[Fluff]

You're welcome & thanks for the feedback

 

[Raggedyman]

I have another formula I'm trying to work out. The following formula is in cell D4:H4 =IF(COUNTIF(D1:H4,MIN(D1:H4))=1,MIN(D1:H4)," ")
In cells H1:H5 I want to find and add the total min number for these cells, what would be the formula?

 

[Fluff]

That formula is going to give a circular reference if you have it in D4

 

[Raggedyman]

Good catch, should be D5:H5

 

[Fluff]

How about
=SUMIF(D1:H4,MIN(D1:H4))

 

[Raggedyman]

More info, in cells D5:H5 I'm have the following =IF(COUNTIF(D1:H4,MIN(D1:H4))=1,MIN(D1:H4)," ")
If there is 1# that differs and is the lowest number from the rest in column D1:D4 the # in the cell is highlighted in red.
I'm looking to total the red #'s in rows 1:4 in cells E1:E4 with only red highlighted #'s

 

[Fluff]

Sorry, but I haven't got a clue what you're talking about. This is the first mention of highlighted cells & how you cannot have a formula in E1:E4 looking at D1:H4 as it will create a circular reference.
Can you post some sample data, the XL2BB add-in can help with that. XL2BB