COUNTIFS/CONTAINS FUNCTION

Paula_

@Genevieve P.

Formula used: =COUNTIFS([Fee Structure]:[Fee Structure], CONTAINS("$2,500", @cell)) Is what I'm using.

If I replace it with just "2500" I get nothing.

Genevieve P.

Hi @Paula_

Yes, that makes sense 🙂 However I'm wondering how you put values in the actual column [Fee Structure]

Did you test the two other COUNTIFS? They'll help us diagnose the issue.  

=COUNTIFS([Fee Structure]:[Fee Structure], "$2,500")

and

 =COUNTIFS([Fee Structure]:[Fee Structure], 2500)

One is looking for text, one is looking for numbers.

Paula_

@Genevieve P.

There are 2 options for each fee level to select - one with T&E and one without. It is a dropdown, so only can enter these formatted values. If I change it to 2500 it returns zero.

$2,500.

$2,500. + T&E

Genevieve P.

Hi @Paula_

Thank you for confirming! This is very helpful. Did you get the answer of 4 with the formula above?

=COUNTIFS([Fee Structure]:[Fee Structure], "$2,500")

^This looks for an exact match, not a "contains" match. I want to ensure that the 4 missing are indeed the ones where only "$2,500" are showing in the cell, and it's not missing some other row.

Can you verify the rows by using a filter with the exact same Conditions?

Paula_

@Genevieve P.

I have changed the values to select from in the dropdown list to contain - No T&E and so it's now counting them properly. I was hoping to not have to go this route, but seems the only way to make it work.

T&E Only

T&E Only - Internal

$2,500. - No T&E

$2,500. + T&E

$3,800. - No T&E

$3,800. + T&E

$7,500. - No T&E

$7,500. + T&E

$10,000. + T&E

$15,000. + T&E

$30,000. + T&E