Sum Formula to add numbers depending on different parameters

[Will Rose]

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

 

[SunnyAlv]

Like this?

=SUMPRODUCT(($C$2:$C$9=1)*($D$2:$D$9=$G4)*($E$2:$E$9))

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)