Help with COUNTIFS Formula: Unparseable Error When Counting Completed Rows After a Date

System

This discussion was created from comments split from: COUNTIFS between dates & criteria..

nracelis

Hi all! Similar to OP, I'm getting an unparseable error with my formula. I'm trying to get a count for rows after a certain date that are marked as complete. Appreciate any insight to help resolve.

=COUNTIFS(([Date Received]:[Date Received], >=DATE(2024, 9, 29)), (Status:Status, "Complete"))

Paul Newcome

@nracelis It looks like you have some parenthesis issues.

=COUNTIFS([Date Received]:[Date Received], >=DATE(2024, 9, 29), Status:Status, "Complete")