Skip to main content
Jonathan M102
Jun 14, 2024 10:05 PM UTC
Solved

How do I do a countif with two conditions?

I have this working with one condition.

=countif(DESCENDANTS(page), x => x."f1" = "Product")

 

But I’d like to do it with two fields rather than just 1.

=countifs(DESCENDANTS(page), x => x."f1" = "Product" AND x."f2" = "TeamA")

Jonathan M102
Jun 14, 2024 10:20 PM UTC

I found my solution I’ll leave the post incase anyone else needs it.

 

=countif(DESCENDANTS(page), AND(x => x."f1" = "Product", x => x."f2" = "TeamA"))

Jonathan

Comments

Jonathan M102
Jonathan M102AuthorAnswer
Jun 14, 2024 10:20 PM UTC

I found my solution I’ll leave the post incase anyone else needs it.

 

=countif(DESCENDANTS(page), AND(x => x."f1" = "Product", x => x."f2" = "TeamA"))

Translate
Jonathan
Richard Udell
Lucid support team
Jun 14, 2024 10:31 PM UTC

Hi @Jonathan M102 , thanks for contributing to the Lucid for Developers Community and for sharing your solution. Please feel free to reach out if you need further assistance with our formulas or APIs. 

Translate