Mulitiple Count of occurrences in different columns
Count of occurrences that appear in multiple columns. For example I have 5
columns that label a particular account as a NEW or OLD, HAPPY or
SAD, 1 or 2, and RED or BLACK. Each account has one of the labels
and I want to count how many are labeled as OLD, HAPPY, 1, and BLACK.
I can't get the "COUNTIF", "COUNT(IF..." formula's to work. Can someone
assist?
--
Thank you,
Ant
|