helps with count under multiple condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need help with count results of column B when it met two criteria in
column A & E.
I am not sure what function to perform. COUNTIF, MATCH etc..
 
Look at SUMPRODUCT:

=SUMPRODUCT(--(A1:A100=Criteria1),--(E1:E100=Criteria2),(B1:B100))

You can put the criteria in a cell

Note: ranges cannot be whole columns.

HTH
 
Back
Top