P Pat Dec 8, 2009 #1 I need a formula to count the blank cells in one column if another column has the text Filed. thank you
I need a formula to count the blank cells in one column if another column has the text Filed. thank you
S Sean Timmons Dec 8, 2009 #2 =SUMPRODUCT((A2:A1000<>"")*(B2:B1000="")) Presuming column A is your nonblank and B is your blank.
