Count If and Is Blank

Options

I am trying to do a formula to count the number of unapproved invoices.

I am counting the column "Approve/Deny" for when it is blank and have this: =COUNTIF([Approve/Deny]:[Approve/Deny], "")

I need to add another argument because it is counting all the rows even when there is no entries. So I tried to count the number of times when the Invoice Date column is not blank but the formula does not work.

Let me know if there is anything I am missing!

Answers

  • Toufong Vang
    Toufong Vang ✭✭✭✭✭
    Options

    Hi, Megan.

    You're already halfway there.

    Instead of COUNTIF(), use the function COUNTIFS() so that you can apply your second criterion, when Invoice Date is not blank.

    COUNTIFS( range1, criterion1, range2, criterion2, range_N, criterion_N )

    =COUNTIFS([Approve/Deny]:[Approve/Deny], "", [Invoice Date]:[Invoice Date], <>"")

    You'll find the Smartsheet functions reference here...