=SUMPRODUCT((A1:A4="Comp "&{"A","B"})*B1:B4)


"IA_sit" wrote:

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