George Excel

  • Thread starter Thread starter George A. Jululian
  • Start date Start date
G

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
 
If you have multiple criteria, always think of SUMPRODUCT:

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