Hi Guys,

I created a formula that will list the unmatched item to column C. My problem is how to count this items.

Example:

Column A
FUR1111
FUR2222
FUR3333
FUR4444
FUR5555

Column B
FUR2222
FUR4444

Column C (Unmatched items)
FUR1111
FUR3333
FUR5555

So in this example, the total number of unmatched is 3. However i don't know how to count this through formulas.

The thing is, the column is C is composed of formulas. Is there a way to count only the result and not the formula.