George Excel

[George A. Jululian]

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

 

[Gary''s Student]

If you have multiple criteria, always think of SUMPRODUCT:

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

 

[George A. Jululian]

Many thanks you gave me a good lesson

Thanks