View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seanie Seanie is offline
external usenet poster
 
Posts: 202
Default SUM all Instances Q

A further twist on =SUM(SUMIF(B:B,{1,2,3,4,5},D:D))

How could I incorporate a further criteria eg. If ColA contains
"London" and if ColB contains one of 1,2,3,4,5 then add up all those
instance in ColD