CountIfs one column is not blank and the other one is

04/19/21
Answered - Pending Review

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!!

Answers

  • Hi @Jodi Steele, try this:

    =COUNTIFS([Date Tip Sheet Submitted]:[Date Tip Sheet Submitted], <>"", [Tip Sheet Archived - No longer relevant]:[Tip Sheet Archived - No longer relevant], "")

  • Thanks @Nathan Gonzalez. Unfortunately that formula produces a 0. Though there are definitely rows where a date is entered but the Tip Sheet Archived is blank.



  • @Paul Newcome @Joelle Roehl , this is my initial post. Do you have any ideas or suggestions? Thanks so much in advance.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    @Nathan Gonzalez's formula should be working. Let's try a minor tweak...

    =COUNTIFS([Date Tip Sheet Submitted]:[Date Tip Sheet Submitted], @cell <> "", [Tip Sheet Archived - No longer relevant]:[Tip Sheet Archived - No longer relevant], @cell <> 1)

  • Yes!! Thank you!

Sign In or Register to comment.