Hi,

I am trying to add entries in a particular column on two criteria:
1.) that the enries i am looking for equal 1.
2.) that the entries i am looking for correspond to "The word customer" in another column to the left.

The columns are not directly next to each other

Customer 1
Stakeholder 1
Customer 1
Supplier 1

The number in bold is the number i want.

Thanks