COUNTIFS Blank & Not Blank

RingJake

Hello,

Formula shouldn't be too difficult, but I'm having some issues. What is the syntax for a function that counts is a cell is blank within certain criteria. Here was my attempt, but it was not working. Will also need the notblank version.

=COUNTIFS({Domain}, [Primary Column]@row, {Metric}, ISBLANK({Metric}))

Thank you!

Paul Newcome

Try this:

=COUNTIFS({Domain}, @cell = [Primary Column]@row, {Metrics}, @cell = "")

=COUNTIFS({Domain}, @cell = [Primary Column]@row, {Metrics}, @cell <> "")

RingJake

Hey Paul,

Thank you for the reply here is what my fx & spreadsheet looks like. This is giving me an "#Invalid REF". Generally I'd think this wouldn't be too difficult, but I'm less familiar with the @cells.

Paul Newcome

Double check that your cross sheet references are created correctly and they they are the same size/shape (for example both need to be entire columns or entire rows).

RingJake

This worked, thank you!