Sumproduct with sumifs formula

I am trying to combine sumifs with sumproduct formula and failing miserably.
I need to accumulate about 30 worksheets of client data into a form. The form requires that I collate the information into bands based on probability of success.
The worksheets are all in the same format. I have attached a short version of the file.
I want excel to take the result of the sumifs formula and multiply it with the corresponding probability as the figures in the client sheets are all grossed up.
Can anyone help with this?
Thank you in advance!