Thread: SUM all Instances Q
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default SUM all Instances Q
Another:

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



Seanie wrote:

Thanks, that would be ideal if I could do =SUMIF(B:B,1,2,3,4,5,D:D),
but it only takes 1 criteria

--

Dave Peterson
Reply With QuoteReply With Quote