Count three things, two of which are from the same column

Hi,

I’m hoping someone can help me on a formula I need in my calculation sheet that counts items from 2 columns within a different sheet. My formula was working until we decided to include more than one status in the count from the second column.

Here’s the formula that was working until I needed to also include a second status in the count:

=COUNTIFS({Country}, "Indonesia", {Status}, "Live project”)

I’d like to adapt/add to the above so that the output also counts Re-prints from the Status column. I've figured out a workaround by counting them separately and then feeding the sum to where I need it but I realise that this will be a simple fix for someone with a better understanding than mine, and I'd like to keep my calc sheet clean and efficient if possible.

I hope this makes sense. Any help would be much appreciated.

Many thanks,

Lee

Find more posts tagged with

Accepted answers

JamesB

@LeeS

Try this formula

=COUNTIFS({Status}, OR(@cell = "Live Project", @cell = "Re-prints"), {Country},"Indonesia")

All comments

JamesB

@LeeS

Try this formula

=COUNTIFS({Status}, OR(@cell = "Live Project", @cell = "Re-prints"), {Country},"Indonesia")

=Chris Palmer

Hi @Lee5

Something like this perhaps?

=COUNTIFS({Country}, "Indonesia", {Status}, "Live project”, {Status}, "Re-prints”)

Lee5

Hi @JamesB thanks for that. Works! Fantastic.

Thanks, @Mr. Chris I thought your suggestion would also work but the count came back as zero. I might be wrong, but I'm thinking that one counts only if Live Project and a Re-print whereas I wanted to count 1 for either status.

Thank you both for your time.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.