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

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

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

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

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

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

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

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"
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


--
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