Count non-blank cells in a row, while conditions in another row are met

[chausj]

example.xlsx

Good morning,

I need function to count non-blank cells in a row, while conditions in another row are met.

Please refer to the attachment for the example. What I need is to count non-blank cells in row F, when cells in row B are equal to "Lobo,Roshan". Cell "Lobo,Roshan" is 27 times in B row, when I filter "Lobo,Roshan" I have 23 non-blank calls in row F. So result which I want to get is "23".

Thanks in advance for your help,
Yury

[samba_ravi]

=SUMPRODUCT(--(B:B=N3),--(LEN(F:F)>0))
Try this
it is better to specify ranges instead of selecting entire Column B and Column F

[shukla.ankur281190]

you can also use this formula

=COUNTIFS(B:B,N3)-COUNTIFS(B:B,N3,F:F,"")