COUNTIF

[Guest]

I am using a COUNTIF formula to pick up the number of inputted data in cells
for example AL, HAL, TO, PD etc which works a treat.

Is there a way I can input two text items in one cell...say AL and TO for
the COUNTIF formula to still pick up the correct data or do I need to rework
my formula?

 

[vezerid]

I am using a COUNTIF formula to pick up the number of inputted data in cells
for example AL, HAL, TO, PD etc which works a treat.

Is there a way I can input two text items in one cell...say AL and TO for
the COUNTIF formula to still pick up the correct data or do I need to rework
my formula?

What exactly do you want? If you are looking for AL and a cell
contains AL-TO, you want it to count it as AL? if so:

=SUMPRODUCT(--ISNUMBER(SEARCH("AL",A$1:$A$100)))

Where A1:A100 hold your data.

HTH
Kostis Vezerides