Countifs to count the cell with formula but return blank value

[logstarter]

I have a column (e.g. Column C) having vlookup formula to get the value from other worksheet. The value could be a blank value.

I am using countifs to count the number of blank value in Column C

=countifs(A:A, ">=1/1/2020", C:C, "")

but it failed to count the blank value..... and returned 0.

I would like to ask how I could check the returned value as blank in countifs in my case?

Thank you for your help.

 

[mrshl9898]

A VLOOKUP that looks at a blank value will return a 0 though, not a blank.

eg:

Could you share some example data or screenshots to assist?