Use a range of cells as criteria in SUMIF

The smallest possible Formula I would like to suggest is:


enter image description here

Your Formula should be re-written like shown below:


You may adjust cell references in the Formula as needed.



The SUMPRODUCT forces the iteration of the Criteria. The others can be full column without detriment. It is basically doing 3 SUMIF()s and adding the results.

FYI: You can also do with SUM: =SUM(SUMIF(A:A,D1:D3,B:B)) as long as you Array enter with Ctrl-Shift-Enter instead of Enter.

enter image description here