sum - SUMIFS multiple criteria in one column, multiple times

Question

hello how I can make formula in cell F6 work ? It returns 0 and should return 97. It's important that criteria will be not in one contiguous range but with few ranges with gaps in between. TY

=SUM(SUMIFS(C1:C5,A1:A5,(D8,D10:D11),B1:B5,(E8:E9,E11)))

question from:https://stackoverflow.com/questions/65891834/sumifs-multiple-criteria-in-one-column-multiple-times

Answer 1

Waitting for answers