ExcelBanter - George Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - George Excel (https://www.excelbanter.com/excel-discussion-misc-queries/211681-george-excel.html)

George A. Jululian[_2_]

George Excel

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

George Excel

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

George A. Jululian[_2_]

George Excel

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

All times are GMT +1. The time now is 08:12 PM.