Need help with formula involving two ranges and count

[Wesleyaford]

Under the Signal column, there are rows of percentages. Under column O(Pos/Targ) and column P(Neg/Targ), there are 0 and 1 indicating that targets were met. To the right you will find a field with percentages that will go from 55 and up to around 250.

I am trying to match and count the percentage column with the target(s) column in the proper field to the right.

Example: 55% 14 10

[NeedForExcel]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[shank_mis]

Are you trying to match Column S with Column I and Count Column O & P ??

In your example: 55% 14 10
14 & 10 are counted value from column O & P right ?
And 55% was matched in column I, right ?

[Wesleyaford]

Yes, the I believe that is correct.

[shank_mis]

Use SUMIFS() and you will get what you want.

For example:
In Cell T4 =SUMIFS($O$4:$O$250,$I$4:$I$250,S4) if your data is within row 4 and row 250.
In Cell U4 =SUMIFS($P$4:$P$250,$I$4:$I$250,S4) if your data is within row 4 and row 250.

Bye....

Hit the "Add Reputation" button if you liked the answer.