Error in condition formating code

[sharadmaxwell]

see the below image
Capture.JPG
A5 is link with A14
A6 is link with A15
A7 is link with A16
A8 is link with A17
A9 is link with A18
A10 is link with A19

MY FORUMLA IS IN B1 i.e =COUNTIFS(B5:B10,"BAL",A5:A10,"<>")

PROBLM IS IF I DELETE A19 AND STILL IN B1 IT COUNT AS 1 IT SHOULD BE 0
SEE BLEOW IMAGE
Capture-1.JPG
PLEASE GIVE SOLUTION
FILE ATTACHED HERWITH

[samba_ravi]

=COUNTIFS(B5:B10,"BAL",A5:A10,"<>")
The above formula will count when there is "BAL" in the range B5:B10 and corresponding row is not blank in Range A5:A10
So in Range A5:A10 have "0" means it is not blank, so you got the value 1
try
=COUNTIFS(B5:B10,"BAL",A5:A10,"<>0")
Note: If you really have 0 value in Column A then also it will not count