Adding a condition to recognize if the external reference cell has any data or no data at all

akain

I have a metrics sheet that pulls data from another sheet. I want the formula to mirror the way the Filter feature works to say "if this cell has any data whatsoever in it (in this case any name) then count it. if the cell has no data, then don't count it."

This is how I have started my formula:

=COUNTIFS({Post Closing Processor}, {Status}, ="Closed")

I want it to recognize only cells where the Post Closing Processor column has a name in it "if" the Status column for the same row reads "closed".

Any help would be greatly appreciated!

Jeff Reisman

You were pretty close! Try this:

=COUNTIFS({Post Closing Processor}, ISTEXT(@cell), {Status}, "Closed")

The ISTEXT function tests if a cell value is text or not. This would exclude cells with date or numeric values. (@cell) tells the system to evaluate each cell in the range. ISTEXT(@cell) says evaluate each cell in the range to see if it is text.

Jeff Reisman

You were pretty close! Try this:

=COUNTIFS({Post Closing Processor}, ISTEXT(@cell), {Status}, "Closed")

The ISTEXT function tests if a cell value is text or not. This would exclude cells with date or numeric values. (@cell) tells the system to evaluate each cell in the range. ISTEXT(@cell) says evaluate each cell in the range to see if it is text.

akain

That works. Thank you so much!