CountIF Formula with Criteria

I have a formula to count how many stores an owner has in our system. It is working great:

=COUNTIF([Primary Contact (Company) (Company)]:[Primary Contact (Company) (Company)], [Primary Contact (Company) (Company)]@row)

(You can see John Voskamp has 91 stores).

I need to determine of the store count, how many are "Open". This is proving more difficult.

I've tried MANY variations on this formula and can't seem to get it to work:

=COUNTIFS([Development Status from SS]:[Development Status from SS], "Open", ([Primary Contact (Company) (Company)]:[Primary Contact (Company) (Company)]))

Any assistance is appreciated!

Find more posts tagged with

Accepted answers

James Keuning

=COUNTIFS([Primary Contact (Company) (Company)]:[Primary Contact (Company) (Company)], [Primary Contact (Company) (Company)]@row, [Development Status from SS]:[Development Status from SS], "Open")

Jgorsich

You left out your ", [Primary Contact (Company) (Company)]@row" bit, giving no criteria for your second range and making the formula incomplete.

Take your original formula (just the countif), make it a "countifs" instead of a "countif" - it should still work just fine. Before the closing parenthesis, add your new range and criteria - like this:

=COUNTIFs([Primary Contact (Company) (Company)]:[Primary Contact (Company) (Company)], [Primary Contact (Company) (Company)]@row,[Development Status from SS]:[Development Status from SS], "Open")

All comments

James Keuning

=COUNTIFS([Primary Contact (Company) (Company)]:[Primary Contact (Company) (Company)], [Primary Contact (Company) (Company)]@row, [Development Status from SS]:[Development Status from SS], "Open")

Jgorsich

You left out your ", [Primary Contact (Company) (Company)]@row" bit, giving no criteria for your second range and making the formula incomplete.

=COUNTIFs([Primary Contact (Company) (Company)]:[Primary Contact (Company) (Company)], [Primary Contact (Company) (Company)]@row,[Development Status from SS]:[Development Status from SS], "Open")

KCam

THANK YOU! worked perfect .

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.