countif not equal to either one of two criteria after index matching

[xcelent]

COUNTIF(INDEX(_1b1_3presrg_1a,MATCH($A17,Data!$B:$B,0)),"<>NA")

the above is my equation now. i cant figure out how to say not equal to either "na" or "blank." right now this answer obviously includes instances of "blank" as part of the count. this is part of a larger equation where i am pulling matches of names in one column and then summing the count of instances from another column where there is not an "NA" nor a "blank." Like this....


=SUM(COUNTIF(INDEX(_1b1_3presrg_1a,MATCH($A18,Data!$B:$B,0)),"<>NA"),COUNTIF(INDEX(_1b1_3presrg_2a,MATCH($A18,Data!$B:$B,0)),"<>*NA*"),COUNTIF(INDEX(_1b1_3presrg_3a,MATCH($A18,Data!$B:$B,0)),"<>*NA*"))

 

[konew1]

By trying to sum all the things that are not blank or NA you will double or triple count the data you are interested in.
Are you setting this up as an array formula?
Have you considered using =SUMIFS() function?

 

[Aladin Akyurek]

You need to re-write Not\Or as And...

COUNTIFS(INDEX(_1b1_3presrg_1a,MATCH($A17,Data!$B:$B,0)),"<>NA",
  INDEX(_1b1_3presrg_1a,MATCH($A17,Data!$B:$B,0)),"")

 

[Aladin Akyurek]

You need to re-write Not\Or as And...

COUNTIFS(INDEX(_1b1_3presrg_1a,MATCH($A17,Data!$B:$B,0)),"<>NA",
  INDEX(_1b1_3presrg_1a,MATCH($A17,Data!$B:$B,0)),"")

Correction: Change "" to "<>".