Need to take a count of a column based on multiple criteria

[PhantomJoe]

So I'm having an issue with a countifs formula. I've got the formula to work but there's one more criteria that I cannot figure out how to account for.

My current formula is as follows: =COUNTIFS(Data!BC:BC,0,Data!I:I,"Closed")+COUNTIFS(Data!BC:BC,0,Data!I:I,"HM Review")+COUNTIFS(Data!BC:BC,0,Data!I:I,"Interviewing")+COUNTIFS(Data!BC:BC,0,Data!I:I,"New Req")+COUNTIFS(Data!BC:BC,0,Data!I:I,"Offer Made")+COUNTIFS(Data!BC:BC,0,Data!I:I,"Screening")+COUNTIFS(Data!BC:BC,0,Data!I:I,"Sourcing")

In the existing formula, I have various statuses in column "I" that I am taking counts of and this part works fine. The additional variable is that sometimes the status is blank (column I) but it still needs to get counted. I cannot find a way to work this into my existing formula.

In theory I want to take a count of column A where column A is not null but column I is null (and only count instances where A is not null and I is null) and have it added as a component to existing countif formula.

Is this possible?

 

[crazydragon84]

+COUNTIFS(Data!BC:BC,0,Data!I:I,"")

this will pick up blanks.

 

[PhantomJoe]

+COUNTIFS(Data!BC:BC,0,Data!I:I,"")

this will pick up blanks.

Worked perfectly, thank you!

 

[crazydragon84]

np. you can also use array formula if your formula is getting too long:

=Sum(COUNTIFS(Data!BC:BC,0,Data!I:I,{"Closed","Review", "interviewing"....})