Countblank

P

Pat

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

Sean Timmons

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

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