# When two "Yes" criterias are met must return TRUE?

#### KyleOliver

##### New Member
Hi Excel World,

I have one table with seven columns. The one column is labeled CORE FUNCTION and another FOREIGN NATIONAL. The value is either "Yes" or "No" for each column.

If both CORE FUNCTION and the FOREIGN NATIONAL reflect "Yes" in both cells of the same row I need to add how many times "Yes" "Yes" is reflected to give me a total.

I hope this is making sense as I have Googled myself to confusion.

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Tell us the column numbers we are dealing with.
And where do you want the results reflected.
Are we dealing with the Range ("A:G") and which of these columns are we looking for "Yes" in ?

Do not tell me the column Header value. I need the column number like "2" or "B"

Do you want the total of all rows in the range or a separate total for each row?

Try this

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #006107}span.s2 {color: #0057d6}</style>=SUMPRODUCT((A1:A7="yes")*(B1:B7="yes"))

in my example, CoreFunctions are all in A1:A7 and ForeignNational are all in B1:B7... Adjust the ranges to match your worksheet.

To obtain the desired count directly...

=COUNTIFS(CORErange,"yes",FOREIGNrange,"yes")

tygrrboi has answered my query with =SUMPRODUCT((A1:A7="yes")*(B1:B7="yes")) which works.

Thanks again!

Hi tygrrboi,

Your formula you suggested I use, works.

Thank you very much!!!

I believe Aladin's is faster. But happy to hear you have two solutions now.

Replies
5
Views
520
Replies
5
Views
1K
Replies
1
Views
384
Replies
16
Views
674
Replies
4
Views
356

1,196,312
Messages
6,014,594
Members
441,828
Latest member
cofracr

### 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.

### Which adblocker are you using?

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

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