I have three columns (A,B,C) and four rows (1,2,3,4). In column “A” the value “100” is entered in all four rows. In column “B” the values are “ACC”, “SEC”, “AAC”, & “AAC”. In column “C” the values are “AAC”, “AAC”, “SEC”, & “AAC”.
I'm looking for a formula that counts the number of times the following conditions occur: the value "100" in column A and "AAC" in either column "B" or column "C". So, in the example the there are four occurrences where there is a "100" in column "A" and an "AAC" in column "B" or "C". What formula will give me the value "4"?
Bookmarks