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

"Cam" wrote:

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..