Counting two conditions


I really don’t know how to ask for what I want. This might already be covered, but this mommy-brain newbie just doesn’t know the correct terminology to ask.

I want to count a list of lines in a table that have x and y. Then, record that number in a certain place on another table. I want it to auto-update based on me changing x or y to a or b… for example.

Clear as mud?


Add a column to the table with items that you want to count.

Use the following formula (and adjust {Field Name}, “x” and “y” to your parameters)

IF(AND(FIND("x", {Field Name}) > 0, FIND("y", {Field Name}) > 0), 1, 0)

Then on your other table, add a Rollup field that looks at this field and sums the values.