Unparseable countifs error with date

CSJ2017

=COUNTIFS([RACD]:[RACD]), DATE(24, 06, 30), [VPO/ED]:[VPO/ED], "Misterly"

Trying to count number of accounts with an RACD Date of 06/30/24 assigned to VPO Misterly using the above formula and i keep getting an unparseable error. What am i doing wrong

JamesB

@CSJ2017

You have your Parentheses closing your Countifs right after your first range. Try this...

=COUNTIFS([RACD]:[RACD], DATE(24, 06, 30), [VPO/ED]:[VPO/ED], "Misterly")

JamesB

@CSJ2017

You have your Parentheses closing your Countifs right after your first range. Try this...

=COUNTIFS([RACD]:[RACD], DATE(24, 06, 30), [VPO/ED]:[VPO/ED], "Misterly")

CSJ2017

It worked! Thank you so much!