COUNTIF

  • Thread starter browneyedgirl_x
  • Start date
B

browneyedgirl_x

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?
 
V

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?
Click to expand...

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
 
Top