Is there a formula to count multiple items in the same column?

Chantelle Ballesteros

Hi! I am trying to create a sheet summary that counts multiple items in one column. for example: =COUNTIFS([policy_name]:[policy_name], "package B", [policy_name]:[policy_name], "Package C") but it gives me 0. Is there a way to count multiple items within the same column?

Paul Newcome

Do you want a count of all cells that contain Package B and Package C within the same cell?

=COUNTIFS([policy_name]:[policy_name], AND(CONTAINS("Package B", @cell), CONTAINS("Package C", @cell)))

Andrée Starå

Hi Chantelle,

@Chantelle Ballesteros

Try something like this.

=COUNTIF(Policy:Policy; OR(CONTAINS("Package B"; @cell); CONTAINS("Package C"; @cell)))

The same version but with the below changes for your and others convenience.

=COUNTIF(Policy:Policy, OR(CONTAINS("Package B", @cell), CONTAINS("Package C", @cell)))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Do you want a count of all cells that contain Package B and Package C within the same cell?

=COUNTIFS([policy_name]:[policy_name], AND(CONTAINS("Package B", @cell), CONTAINS("Package C", @cell)))

Chantelle Ballesteros

The Packace types aren't in the same cell, just in the same column. I want a total count of all instances of Package B, C, D and E within the Policy column. I'll attach a screenshot. Also, I changed the name of the column to Policy, instead of 'policy_name'.

Andrée Starå

Hi Chantelle,

@Chantelle Ballesteros

Try something like this.

=COUNTIF(Policy:Policy; OR(CONTAINS("Package B"; @cell); CONTAINS("Package C"; @cell)))

The same version but with the below changes for your and others convenience.

=COUNTIF(Policy:Policy, OR(CONTAINS("Package B", @cell), CONTAINS("Package C", @cell)))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Andree is correct. You would use the same pattern I provided except use an OR instead of an AND.

Chantelle Ballesteros

Thank you both for your help! That worked :)

Andrée Starå

@Chantelle Ballesteros

Excellent!

Happy to help!

Paul Newcome

Happy to help. 👍️

Susan Swisher

I was searching and searching for this option; and found your response/post and boom .. it worked like a charm! Thank you, so much!👊

Andrée Starå

@Susan Swisher

Excellent!

Happy to help!

Glad it was helpful for you as well!