View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DogmaDot DogmaDot is offline
external usenet poster
 
Posts: 8
Default Sum in a column if there are 3 conditions in another column

I need to find the total from Col B if Col A is one of the 3 possibilities

A B
DONE 0
DONE 60
OBS 40
POST 55
DONE 40
DONE 0
DONE 47
POST 55

DONE RESULT
OBS RESULT
POST RESULT