Ignoring excel/pivot counting Blank Cells..

Dear Experts,

I need help in the attached excel sheet. I have a huge data where I need to filter particular status. I had put IF condition with "" value (=IF(E2="Open","1",IF(E2="WIP","1","")).

When I check the count, the total counts the blank cells too. The same issue happens in Pivot.

Any suggestion on how to get rid of blank cell?

Attached a sheet for reference

You could try COUNTIF instead:

=COUNTIF(F2:F10,1)

Or if you have multiple non-blank values maybe:

=COUNTA(F2:F10)-COUNTIF(F2:F10,"")