Countifs in google sheet

Question

I have problem with using COUNTIF in a formula,

I have three columns: O with values Yes, AE with values returning self-serve, self-serve and assisted and AH with dates.

I need to count based on each date users that have yes in column O and having only returning self-serve and self-serve in column AE (exclude those with value assisted). I tried to this formula:

=IF(OR(AND('New Self Serve'!AE:AE="new self-serve",'New Self Serve'!O:O="yes"),AND('New Self Serve'!AE:AE="returning self-serve",'New Self Serve'!O:O="yes")),countifs('New Self Serve'!AH:AH,A597)) but it doesn't work properly and returns values FALSE.

Answer 1

You mentioned:

I need to count based on each date users that have yes in column O and having only returning self-serve and self-serve in column AE (exclude those with value assisted).

You could use a query instead

=QUERY(O2:AH17,"select count(O) where AE contains 'self-serve' and O='yes' group by AH label count(O) 'COUNTED'")

Functions used:

• QUERY