View Single Post
 
Old 02-04-2015, 12:24 PM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Competent Performer
 
Join Date: Nov 2011
Posts: 110
Alaska1 is on a distinguished road
Default 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.
Reply With Quote