Countif Question

Lior Molvin

When I apply a countif formula to an entire cell with multiple functions, it only works when the function is the "only" selection. In other words countif is only finding the exact match. I'd very much like to count every time the object item within the column is found.

I'm using this:

=COUNTIF(IQP:IQP, {QA Reference Page Range 2})

Any recommendations?

Mark Cronk

Hi @Lior Molvin ,

Not sure I understand what you're doing. COUNTIF needs a range and a value. Is {QA Reference Page Range 2} a single cell with a value?

If IQP is a multiselect column and you want to count every instance where the value of {QA Reference Page Range 2} appears you need to use HAS. The formula would be:

=COUNTIF(IQP:IQP, HAS(@cell, {QA Reference Page Range 2}))

Help?

Mark

Lior Molvin

helpful yes, but IQP has multiple values, HAS references IQP:IQP for Reference page single cell. I'm still getting logic fails :(

Mark Cronk

What error does it return?

Try hard coding a value to count and see if that returns an answer =COUNTIFS(IQP:IQP, HAS(@cell,"insert a known value"))

Mark