SUMPRODUCT with embedded MAX/MIN

Hi,

Please find attached excel file, i have used MIN & MAX function instead of SUMPRODUCT function i hope will help you.

if you Satisfy with my answer so please Add reputation. you can click your right side * button.

Imran.