SUM of #N/A cells (#N/D in italian EXCEL)

  • Thread starter Thread starter kayard
  • Start date Start date
K

kayard

Hi,

I'd like to know how I can sum, say 100 cells among which there is on
cell with #N/A, without getting #N/A as a result.

Thamks in advance for your support

Paolo

Ital
 
In English, I'd use:

=sum(if(isnumber(a1:a100),a1:a100))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.
 
Try something like this:

English version:
=SUMIF(A1:A100,"<>#N/A",A1:A100)

Italian version?
=SUMIF(A1:A100,"<>#N/D",A1:A100)

Does that help?

Regards,

Ro
 
And the *short* Italian version:<bg>

=SUMIF(A1:A100,"<>#N/D")

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Ron Coderre" <[email protected]>
wrote in message

Try something like this:

English version:
=SUMIF(A1:A100,"<>#N/A",A1:A100)

Italian version?
=SUMIF(A1:A100,"<>#N/D",A1:A100)

Does that help?

Regards,

Ron
 
Back
Top