View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IA_sit IA_sit is offline
external usenet poster
 
Posts: 1
Default SumIf with OR criteria

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