=SUMPRODUCT((A2:A1000<"")*(B2:B1000=""))

Presuming column A is your nonblank and B is your blank.

"Pat" wrote:

I need a formula to count the blank cells in one column if another column has
the text Filed. thank you