Countif statements
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.
|