Isblank

Stephen Corrigan

i have the below formula to count "VCD" in a Column

=SUM(COUNTIFS({Hubgrade Status Range 1}, HAS(@cell, "VCD")))

I want it to also check another column and give me back the result if that is blank. Is this possible to do?

Paul Newcome

You would add in another range/criteria set to the COUNTIFS.

=COUNTIFS({Hubgrade Status Range 1}, HAS(@cell, "VCD"), {next range}, @cell = "")

Paul Newcome

You would add in another range/criteria set to the COUNTIFS.

=COUNTIFS({Hubgrade Status Range 1}, HAS(@cell, "VCD"), {next range}, @cell = "")

Stephen Corrigan

Thanks Paul

Paul Newcome

Happy to help. 👍️