COUNTIFS results in Zero (and NOT for same reason as in rsmith's question)

Why am I getting no errors, but a 0 (expressed as a percent as formatted) when using the following formula?

Please note that I am NOT the person who named these columns or the list of values therein, but you've gotta work with what you're given, right?

Here's the formula:

=COUNTIFS([SF Phone decom'd/removed]2:[SF Phone decom'd/removed]99, ="Done - all phone needs met", [SF Phone decom'd/removed]2:[SF Phone decom'd/removed]99, ="N/A" / COUNT([SF Phone decom'd/removed]2:[SF Phone decom'd/removed]99))

Thanks!

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

@khankoff Your original formula had some misplaced parenthesis, and your syntax was off for what it looks like you were trying to accomplish.

Your second formula should work.

All comments

khankoff

FYI - I'm now wondering whether it's because I'm referencing the same range twice in one formula before I use the count. If that's the case, then I need to know how to identify two criteria in one column reference.

khankoff

I may have solved my own problem. Please have a look at this formula, and tell me what is wrong with it that hasn't yet come to bite me on the butt. Seems to be working, but I am leery...

=SUM(COUNTIF([SF Phone decom'd/removed]2:[SF Phone decom'd/removed]99, "N/A"), COUNTIF([SF Phone decom'd/removed]2:[SF Phone decom'd/removed]99, "SF phone decom'd & removed")) / COUNT([SF Phone decom'd/removed]2:[SF Phone decom'd/removed]99)

Paul Newcome

@khankoff Your original formula had some misplaced parenthesis, and your syntax was off for what it looks like you were trying to accomplish.

Your second formula should work.

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.