CountIfs one column is not blank and the other one is

Jodi Steele · 04/19/21

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

Nathan Gonzalez · 04/20/21

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], "")

Jodi Steele · 04/21/21

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.

Jodi Steele · 04/26/21

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

Paul Newcome · 04/26/21

@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)

Jodi Steele · 04/26/21

Yes!! Thank you!

CountIfs one column is not blank and the other one is

Answers

Help Article Resources

Categories