Sum Formula to add numbers depending on different parameters

Will Rose

New Member
Joined
Dec 2, 2011
Messages
5
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
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.

1709797606299.png


The actual spreadsheet itself is quite detailed so won't lend itself to a pivot table, any help would be greatly appreciated.

TIA

Richard
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Like this?

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

1709798565959.png
 
Upvote 0
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’)
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,099
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top