Dadgummit! I almost went there. Stopped before adding the outside SUM(), it
didn't work as an array formula, so I went with the individual SUMIF()s.

Hope OP sees your post.

"Dave Peterson" wrote:

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
.