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