CountIfs one column is not blank and the other one is
I'm trying to count rows that have a date in one cell but is blank (no checkmark) in the other. Is that possible? I've done multiple iterations, all unsuccessfully. Here's the last one I've tried:
=COUNTIFS([Date Tip Sheet Submitted]1:[Date Tip Sheet Submitted]1129,<>, [Tip Sheet Archived - No longer relevant]1:[Tip Sheet Archived - No longer relevant]1129 ISBLANK(@cell))
Essentially I'm trying to create a running total of how many documents have been submitted (column is set up as a Date format) but still waiting for approval (column is a checkmark format). I'd be grateful for any help!!