Formula to count both names in one cell

Nkeiruka. Aguocha

Hello,

I'm trying to count a total of two different names in a column,

A-Mission

B=Portfollio/Mission.

This is what I have so far, and I know I'm doing something wrong here. 😆. Please assist, thank you!!!

=COUNTIF({Copy of Change Request Range 1}, "Mission", COUNTIF({Copy of Change Request Range 1}, "Portfollio/Mission"))

Find more posts tagged with

Accepted answers

Lucas Rayala

Try this:

=COUNTIF({Copy of Change Request Range 1}, OR(@cell ="Mission", @cell="Portfollio/Mission"))

Lucas Rayala

glad it worked!

All comments

Lucas Rayala

Try this:

=COUNTIF({Copy of Change Request Range 1}, OR(@cell ="Mission", @cell="Portfollio/Mission"))

Nkeiruka. Aguocha

Hi @Lucas Rayala

Thank you!! I'm actually trying to catch a total of both of them together and not separately. I did the formula but it came back with the incorrect amount. Thanks!

Nkeiruka. Aguocha

Hi @Lucas Rayala

You know what, never mind. It was my mistake, thanks so much for your help!!

Lucas Rayala

glad it worked!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.