Hi Guys,

I'm experiencing a small problem with the Countif function. The criteria is as follows:

A
B
C
D

However, the range in which the formula is searching for has cells that have data like the following:

A
B

The above is in ONE cell and the Countif function doesn't counts the data within these cells. Does any one know how a work around for this?

Thanks in advance for any help.