countifs in google sheet excel

I have problem with formule countif,

I have three columns O with values Yes, AE with values returning self-serve, self-serve and assisted and third column 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 formule:

=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.