Hi, could anyone help me with a formula please. I'm wondering if there is a way to create a summary sheet which will add values depending on certain parameters as per screenshot attached. I.e a formula that will look at the "set" number and then the "comp" percentage over an array of data and then add all the values that are, say, set 2 at 40% etc etc.
The actual spreadsheet itself is quite detailed so won't lend itself to a pivot table, any help would be greatly appreciated.
TIA
Richard
The actual spreadsheet itself is quite detailed so won't lend itself to a pivot table, any help would be greatly appreciated.
TIA
Richard