hi
try something like this.
=SUMIF(A2:A5,"Comp A",B2:B5)+SUMIF(A2:A5,"Comp B",B2:B5)

and i think it adds up to 60.

regards
FSt1

"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