count all #N/A

[neveu]

hi how can i use the countifs formula to count all the information from a tabel that is not #N/A and also meets another criteria
in the case below i would need to know what is the total number of information from column col1 that is "X" and all the information in column col 2 that is NOT #N/A

col1 col2
x #N/A
y #N/A
x dasd
y das

 

[Jon von der Heyden]

Assuming that data is in A1:B4.

=SUM(IF(NOT(ISERROR(B1:B4)),--(A1:A4="x")))

Confirmed with Ctrl+Shift+Enter not just Enter

 

[neveu]

thank you,
it works perfectly

 

[Aladin Akyurek]

With CountIfs of 2007 and beyond...

=COUNTIFS(A2:A5,"X",B2:B5,"<>"&NA())

 

[Scott Huish]

If you don't have XL2007, also:

=SUMPRODUCT(1-ISNA(B1:B4),--(A1:A4="x"))