SUMIFS with error as criteria

[tiredofit]

Assume I have this data:

1    a
2    b
3    a
10  d

If I write:

=SUMIFS(A:A, B:B. "a")

I get the value of 4.

But if I had this data:

1    #N/A
2    b
3    #N/A
10  d

and I want to SUMIFS based on #N/A, eg:

=SUMIFS(A:A, B:B, "#N/A")

I don't get the value of 4.

How would I do it

Thanks

 

[RoryA]

What value do you get?

 

[tiredofit]

It's sorted.

I realise my data as incorrectly formatted.

Thanks