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

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

Many thanks you gave me a good lesson

Thanks

"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