CountIfs for not blank cells with condition

Hello All,

I would like to request for your assistance with the below. I have 2 worksheetsm Report and Data. In the Data worksheet Col A contains list of names, some are multiple instances while B contains comments.

On worksheet report, the list of names serves as a tally and I would like to know how I can count based on the names in Data, the number of instances where the cell contains comments, except for "NA"

E.g

Alm = 0
David = 1
Faye = 1 because her other comment is NA which is excluded.

I'm trying to combine =countifs and not is blank condition =COUNTIFS(A:A,F2,B:B,NOT(ISBLANK(B:B))) for example, but can't get it to work.

Thank you so much!

Put this formula in G2:

=COUNTIFS(A:A,F2,B:B,"<>",B:B,"<>NA")

then copy down.

Hope this helps.

Pete

Hello Sir Pete_UK and Sir FlameRetired, thank you so much for the assistance. The given code by sir Pete is working extra perfect! Cheers!