COUNTIFS/CONTAINS FUNCTION
Answers

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.

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.

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

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?

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
Help Article Resources
Categories
Check out the Formula Handbook template!