Adding Different Variables

Hi

Could someone help me compute a SUMPRODUCT or alternative to pull the data. I have about 5,000 rows.

In the attachment I have laid the data as it is in the data tab

I am trying to pull data into the customer tab frim data tab.

From the data tab it will look at the variables Division, Workstream, Lever and then apply the amount in Weighted Pipeline etc.

Thanks

Try this in D2, copy right and down.

Formula:

Please Login or Register  to view this content.

Thank you so much Jason.b75 for a prompt resolution