=IF(ISTEXT..... formula only half works, it returns some sequential numbers but not others

Hi

I have a formula that half works, =IF(ISTEXT(C19)+(F19),COUNTA($C$19:C19,$F$19:F19),"") This is currently returning sequential numbers correctly for the first part (the ISTEXTC19 and COUNTA($C$19:C19)) but returning 'value' for the cells where it is looking up text in column F.

There is never text in the same row for column C and F. Can anyone point out where I'm going wrong?

Thanks

I would guess you need:
=IF(AND(ISTEXT(C19),ISTEXT(F19))
or
=IF(OR(ISTEXT(C19),ISTEXT(F19))
as your equality for the if statement looks iffy but it's not really clear what you are trying to do...

Hi raguldy

thank you for the reply, the suggestions you made did not really return what I hoped for but that's because my explanation was not great at all. I have mocked up something that hopefully means you will see what I am trying to achieve.

In column C (Modal Message) and in column F (Action Message) are some text cells, these will be messages that appear in sequence and to help other users who will end up with my spread sheet I would like column B (message #) to have sequential numbers representing cells that have 'text' in them. This will be so I can say 'please look at message 5' for example and they can scan down and across. My little twist is that there are extra pieces of data in columns D (Data 1) and E (Data 2) that I do not want included in the number count in column B.

Does that help?


message # Modal Message Data 1 Data 2 Action Message Screen #
1 Text
2 Text
Data Data
#VALUE! Text 1
4 Text
5 Text
6 Text
#VALUE! Text 2
8 Text
Data Data
Data Data
#VALUE! Text 3
#VALUE! Text 4
11 Text
12 Text
Data Data
#VALUE! Text 5
14 Text
#VALUE! Text 6


So in column B the formula so far is =IF(ISTEXT(C19)+(F19),COUNTA($C$19:C19,$F$19:F19),"") which returns sequential numbers interspersed with '#value' which I would like to be proper numbers.

The formula in column G is =IF(ISTEXT(F19),COUNTA($F$19:F19),"") which works perfectly.

Hi - please upload an example workbook with an example of your data and the corresponding required results. To upload a workbook, click go advanced and then attachments.

Thanks, I didn't see the go advanced section.

Hi, change your formula in B3 to:
=IF(OR(ISTEXT(C3),ISTEXT(F3)),COUNTA($C$3:C3,$F$3:F3),"")

Hurray!!!!!!

Thank you so much! that works perfectly! Thank you, thank you, thank you!!!!!!