Is there any way I can do countifs() function...

[Administrator1]

Is there any way I can do countifs() functions directly in AppSheet. I need to count something based off of 3 criteria. For example, I need a formula that examines the following sheet and gives me a running count based off of 3 columns.

1. a specific user (i.e. useremail())

2. a specific type of service (i.e. Type 1) 3. has a specific status (i.e. Pending).

I’ve tried using the count(select(in())) function in a virtual column, but I can only get it return a single column of data, or compare a single “value” when counting. I can’t seem to nest it with “if()” or “and()”. Any ideas?

Thanks!