A
Ant
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?
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?