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

khankoff · 03/12/20

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!

Paul Newcome · 03/13/20

@khankoffYour 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.

khankoff · 03/12/20

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 · 03/12/20

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 · 03/13/20

@khankoffYour 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.

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

Best Answer

Answers

Help Article Resources

Categories