Because SUMIFS requires all criteria to be true. i.e.

"Criteria 1 AND Criteria 2 AND Criteria 3" must be true

This is impossible because each cell in D5:D24 can't be three different things at once.
_________________________
Christian
#40104192 120Gb (no longer in my E36 M3, won't fit the E46 M3)