Array formula. (Ctrl+Shift+Enter)

=SUM(((A1:A4="Comp A")+(A1:A4="Comp B"))*B1:B4)

John

Ο χÏ�ήστης "IA_sit" Î*γγÏ�αψε:

Data as below
Comp A 10
Comp B 50
Comp C 80
Comp D 100

Assume data starts from column A, I want to sum data in column B when column
A is either Comp A or Comp B (answer would be 90). Many posts asked for 2
criteria is usually AND so those formulea don't work out so far.

Thanks in advance