COUNTIFS - Referencing two columns

Leyla Goudie

Hi -

I keep getting an UNPARSEABLE error with my COUNTIFS formula. My intention is to have a summary of how many documents are pending approval from another department -

I need to return a count for how many rows have a date included in the "Date Submitted to OMB" column, but are missing a date in the "Date Returned from OMB" column.

Any help is appreciated. Thank you.

MCorbin

Try this:

=COUNTIFS([Date Submitted to OMB]:[Date Submitted to OMB], ISDATE(@cell), [Date Returned from OMB]:[Date Returned from OMB], NOT(ISDATE(@cell)))

MCorbin

Try this:

=COUNTIFS([Date Submitted to OMB]:[Date Submitted to OMB], ISDATE(@cell), [Date Returned from OMB]:[Date Returned from OMB], NOT(ISDATE(@cell)))

Leyla Goudie

Thank you!! This does exactly what I need it to. I appreciate the quick help.