excel formula does not work

**comp818** · 02-24-2011, 09:44 PM

Please see the attachment of Excel sheet. I need help with formula. If you click on AB17 you will see the current formula which is working for T20, V20, X20, Z20 and AB2 expect R20. This formula doesn't work on R20 line. Please help me.

**comp818** · 02-24-2011, 09:55 PM

I need help with formula. If you click on AB17 you will see the current formula which is working for T20, V20, X20, Z20 and AB2 expect R20. This formula doesn't work on R20 line.

**teylyn** · 02-24-2011, 10:31 PM

Help me out here. Which sheet?

**teylyn** · 02-24-2011, 10:34 PM

cell AB17 has

=COUNTIF(BG21:BG357, "2 or more")

T20, V20, X20, Z20 have text.

AB2 does not really exist, since row 2 is merged.

Your explanation does not match with the file. Please explain.

**comp818** · 02-24-2011, 10:57 PM

Originally Posted by teylyn

cell AB17 has

=COUNTIF(BG21:BG357, "2 or more")

T20, V20, X20, Z20 have text.

AB2 does not really exist, since row 2 is merged.

Your explanation does not match with the file. Please explain.

The problem is that the formula doesn't work on R20 line.

**teylyn** · 02-24-2011, 11:05 PM

Which formula? In which cell?

R20 has the text "Hp"

Please remember that we don't know your workbook as well as you do. You will need to explain a bit more and point out what the problem is.