Required formulae for sum with multiple conditions

Dear experts,

I have attached sample data with wanted results. first i tried myself using sumifs formulae but not getting required result.
that's why i m posting here to get help from the experts.

i want to search whole data for sumif.

Thanks