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.
Bookmarks