Hi all,

I need your help

I have table with 3 column I need formula to count in column B if it is red
and the code A11b to have the quantity


A B C
Type Colour Code

Apple Red A11b
Apple Red A11b
Apple Green A11c
Apple Green A11c
Apple Green A11c
Apple Red A11b
Apple Red A11b


Regards