I am using the countif statement to count how many customers have a yes in column h and j. So if there is a yes in both the fields I want the countif statement to count it. What is the best way to do this formula?

Example
Customer1 Yes in H Yes in I
Customer 2 Yes in I (so the statement would not count this one because it is not both columns.



Eventually when I figure out the formula and I am going to want to add third column J.

Have a look at the COUNTIFS or the SUMPRODUCT function

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you. I looked at those in excel and applied them. They do not seem to be working.

Please find an example attached.

Attached Files

Yesorno.xlsx (9.0 KB, 11 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for your help.

I have one more I have been working on. I want to count the blanks in a document. My worksheet is a table. I am able to count the number of blanks in the table but I want narrow it to specific cell.
=COUNTBLANK(Table2)
I want to be able to count the blanks in the table and column d and as I added data it continues to count the blanks.