HELP NEEDED using Sumif, Xlookup, from 2 different tables.

Hello,

I am trying to write a formula in Sheet4 will give me the correct sales price of each Plan according to which level it is. The Options for each level is determined on Sheet3 and the price of the Option per Plan is in the pivot table.

I've been Trying to use =SUMIF, =SUMIFS & =Xlookup, to achieve this but i can not seem to find the right combination.

You have neither a sheet4 nor a sheet 3?

Im guessing you meant Sheet4=sheet1 and sheet3 = Std Opt...

Having said that, rather making us run around trying to guess where all the info is/where to find it, explain exactly what you want done, where the info is (cell ref etc) and how you would do this manually.