![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jamal NUMAN | Excel | 16 | 11-15-2022 11:59 PM |
![]() |
stuwoolf | Excel | 2 | 01-10-2015 01:58 PM |
getting IF and OR to work for 3 IF statements | nero6014 | Excel | 3 | 09-16-2014 07:28 AM |
![]() |
Alaska1 | Excel | 1 | 05-14-2014 08:21 AM |
IF statements that shifts to right. | kent | Excel | 0 | 01-19-2006 02:23 PM |