AutoSum and text
 

I'm using Excel 2003 and I want to add a column of 20 cells. The cells have
the value of 0, 3, 5 or n/a. Can I just use AutoSum and it will ignore the
n/a but total the numbers correctly?

Thanks

AutoSum and text
 

You'll need to use Sumif()

e.g

=SUMIF(F1:F6,"<#N/A",F1:F6)

where F1:F6 is your range of cells to sum.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113302

AutoSum and text
 

Hi,
try

=SUMIF(C5:C7,"<#DIV/0!")

change range to fit your needs

"SueG" wrote:

I'm using Excel 2003 and I want to add a column of 20 cells. The cells have
the value of 0, 3, 5 or n/a. Can I just use AutoSum and it will ignore the
n/a but total the numbers correctly?

Thanks

AutoSum and text
 

Opps use

=SUMIF(C5:C7,"<#N/A")

"SueG" wrote:

I'm using Excel 2003 and I want to add a column of 20 cells. The cells have
the value of 0, 3, 5 or n/a. Can I just use AutoSum and it will ignore the
n/a but total the numbers correctly?

Thanks