If you have multiple criteria, always think of SUMPRODUCT:

=SUMPRODUCT((A1:A100="Apple")*(B1:B100="Red")*(C1: C100="A11b"))

--
Gary''s Student - gsnu200816


"George A. Jululian" wrote:

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