Vlookups and array formulas

Hello I have two columns in excel:
Column A (A2:A56) contains contract codes values
Column B(b2:b56) contains renewed contract codes values

I would like to count the number of contract codes values that have been renewed (matching Column B with Column A). I would like to achieve that without adding a column (altering my structure)

Is it possible to achieve that by using array formulas

(If I add a column and I perform a vlookup then I can straightforward count the number of matches)

My Array Formula looks as follows (My aim is to count the number of cells in column B3:B9 that do not return an error(have a match) with a cell in column A3:A9

Please Login or Register  to view this content.

To clarify please see attachment
Many Thanks

Try this ...

=SUM(--(COUNTIF(Table1[CONTRACT CODE],Table1[RENEWAL OF CONTRACT CODE])>0))

Hello,
Thanks for your reply
It does not work as COUNTIFS cannot compare two columns
The criteria cannot be a column should be a value
My challenge is to be able to formulate an array formula that vlookups every cell in CONTRACT CODE again the whole column of RENEWED CONTRACT CODE and returns 1 if found 0 if error. Subsequently it sums up the "virtual array" of 1s and 0s
Regards
Dora

Did you try Daffodil11's formula: it returns a result of 3.

Thanks. Apologies. Daffodil11's formula works