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

[kayard]

Hi,

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

Thamks in advance for your support

Paolo

Italy

[Ron Coderre]

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

[Dave Peterson]

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.


kayard wrote:
>
> Hi,
>
> I'd like to know how I can sum, say 100 cells among which there is one
> cell with #N/A, without getting #N/A as a result.
>
> Thamks in advance for your support
>
> Paolo
>
> Italy
>
> --
> kayard
> ------------------------------------------------------------------------
> kayard's Profile: http://www.excelforum.com/member.php...o&userid=24716
> View this thread: http://www.excelforum.com/showthread...hreadid=565187

--

Dave Peterson

[RagDyeR]

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
news:[email protected]...

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=565187