ExcelBanter - Countblank

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Countblank (https://www.excelbanter.com/excel-worksheet-functions/250509-countblank.html)

Pat

Countblank

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

Sean Timmons

Countblank

=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

All times are GMT +1. The time now is 02:12 PM.