Hi Ant

You need a SumProduct formula.

I assume one column is used for one label pair.

With labels in column A:D, this formula will work:

=SUMPRODUCT(--(A1:A10="OLD"),--(B1:B10="Happy"),--(C1:C10=1),--(D1:D10="black"))

Hopes this helps.

---
Per


"Ant" skrev i meddelelsen
...
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