Using COUNTIF and ISBLANK together

[DeavenW]

I am trying to get my file to count all of the blank cells within a specific range of cells but only if it has a specific number in column A. The formula I am using to get the first number is (=COUNTIF('Full Region Report'!$A$3:$A$1500,701). What I need the next formula to do is pull from the same tab however I need it to count how many cells are blank on column E but only in the rows that have 701 in column A. I need the formula to produce the number of blanks within that range so that I don't have to hand sort to find the data. Hopefully I explained that well as I am going crazy trying to figure it out. Thanks in advance if anyone knows!!

 

[Fluff]

Hi & welcome to MrExcel.
Maybe

=COUNTIFS('Full Region Report'!$A$3:$A$1500,701,'Full Region Report'!$E$3:$E$1500,"")

 

[DeavenW]

Hi & welcome to MrExcel.
Maybe

=COUNTIFS('Full Region Report'!$A$3:$A$1500,701,'Full Region Report'!$E$3:$E$1500,"")

Thank you so much that seems to be working!!

 

[Fluff]

You're welcome & thanks for the feedback.