If condition if two tables have same value

[blackbranded]

I have two Dataset
one is Inteview Details and 2nd On board details

want to count if Interview details have column name is final status and looking for value is "Extended" and On Board have Status "Extended" if its match then interviews Status count zero
Plese find the Google sheet (sample data)
https://docs.google.com/spreadsheets/d/1DWl1e7td2RbT56RQh2O7vZjqUMlM77EUcSOj-VYnydw/edit?usp=sharing

 

[AlanSidman]

You have posted in the Power Query sub forum. Is this an excel PQ issue or a Google Sheets issue. If an excel issue, please repost your file to this forum.