Sumif

[shaunkaz]

HI

Can someone please help with a formula

Column A Column B
24
30 #n/a
55
48 #n/a
64 #n/a
32

In column A i have numbers
In column B is a formula which brings up #N/a

What I want is to sum up column A which have #N/a in column B

I have tried the following formula but doesn't work

=sumif (A1:b10,"#N/a",B1:b10)

Any help with this would be appreciated

Thanks
Shaun

 

[VoG]

Try

=SUM(IF(ISNA(B1:B10),A1:A10))

confirmed with CTRL + Shift + Enter, not just Enter.

 

[RichardMGreen]

Try this:-
=sumif (A1:b10,"=#N/A",B1:b10)

 

[shaunkaz]

Excellent..

Thanks for your help

 

[Weaver]

I tried your original formula on a sample set and it worked fine.

When you say 'doesn't work', do you mean you get an error or do you mean you get unexpected/inconsistent results?