Countifs and Is not blank

Megan Sultze

I am trying to create a formula where it counts the number of rows when an invoice has not been approved. This is what I have and instead of changing the name for each person, I want to create one where it counts when the Approver column is not blank.

=COUNTIFS({Approver4}, "Eric Delie", {Hold}, "")

Mark Cronk

Try: =COUNTIFS({Approver4}, NOT(ISBLANK(@celly@cell)), {Hold}, "")

@cell references each cell in the range. No need to change that. Are you getting an error or incorrect response?

Mark

Mark Cronk

Hi,

Try:

=COUNTIFS({Approver4}, NOT(ISBLANK(@cell), {Hold}, "")

An alternative would be:

=COUNTIFS({Approver4}, ISTEXT(@cell), {Hold}, "")

Work?

Mark

Megan Sultze

@Mark Cronk

No, I can't get that to work. What is the "@cell"? Do I have to replace that with something?

Mark Cronk

Try: =COUNTIFS({Approver4}, NOT(ISBLANK(@celly@cell)), {Hold}, "")

@cell references each cell in the range. No need to change that. Are you getting an error or incorrect response?

Mark

Megan Sultze

@Mark Cronk Yes, that did work! Thank you!

Mark Cronk

Excellent. Glad you found a solution. Thank you for contributing to the community.

Mark