Hi Excel Forum,

I am new to this forum and looking for some help on the following:-

This is my current formula for calcuating the number of failed assets for a specific country

=SUMPRODUCT(ISNUMBER(FIND("GB_cz",QSC_Failed!$D$2:$D$2249))*ISNUMBER(FIND("UNIX",QSC_Failed!E$2:$E$2249))*ISNUMBER(FIND("105053",QSC_Failed!$G$2:$G$2249)))+
SUMPRODUCT(ISNUMBER(FIND("GB_cz",QSC_Failed!$D$2:$D$2249))*ISNUMBER(FIND("Linux",QSC_Failed!E$2:$E$2249))*ISNUMBER(FIND("105053",QSC_Failed!$G$2:$G$2249)))+
SUMPRODUCT(ISNUMBER(FIND("GB_cz",QSC_Failed!$D$2:$D$2249))*ISNUMBER(FIND("Solaris",QSC_Failed!E$2:$E$2249))*ISNUMBER(FIND("105053",QSC_Failed!$G$2:$G$2249)))+
SUMPRODUCT(ISNUMBER(FIND("GB_cz",QSC_Failed!$D$2:$D$2249))*ISNUMBER(FIND("AIX",QSC_Failed!E$2:$E$2249))*ISNUMBER(FIND("105053",QSC_Failed!$G$2:$G$2249)))+
SUMPRODUCT(ISNUMBER(FIND("GB_cz",QSC_Failed!$D$2:$D$2249))*ISNUMBER(FIND("FreeBSD",QSC_Failed!E$2:$E$2249))*ISNUMBER(FIND("105053",QSC_Failed!$G$2:$G$2249)))+
SUMPRODUCT(ISNUMBER(FIND("GB_cz",QSC_Failed!$D$2:$D$2249))*ISNUMBER(FIND("HP-UX",QSC_Failed!E$2:$E$2249))*ISNUMBER(FIND("105053",QSC_Failed!$G$2:$G$2249)))

Now to this I want to add another string, which can calculate the blank cells under the range $E$2:$E$2249 for the Czech Republic country under Column D with the code 105053 under the column G.

I have tried COUNTBLANK & COUNTIF array but they dont give me the correct number, would appreciate if one of you can help me with it.

Thanks & Regards
Raghu