Multiple CountIfs Not Working

Hi Guys, I've just stumbled upon this great article https://www.ablebits.com/office-addi...nctions-excel/ and for a future project I have in mind Array Formulas are the way to go.
My query is not relating to an Array Formula but I'm unfamiliar with the CountIfs function in the 2nd example with the tutorials.

I'm pretty sure my code is spot-on but it's not working.

Please Login or Register  to view this content.

Oddly if I change the formula like an array formula below it works. I know it's not actioned like an array formula but to me it's referencing the apples and lemons like an array; referencing the criteria2 as an array instead of superfluously having to reference the criteria ranges and criteria again with lemons.

Please Login or Register  to view this content.

I'd be grateful if someone could advise why the basic CountIf is not working?

Thanks AliGW, makes sense, thank you very much, I should read on in the examples which do go on to and/ or operators being used in Array Formulas.