Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autosum | Excel Discussion (Misc queries) | |||
AutoSum Help | Excel Worksheet Functions | |||
Autosum | Excel Discussion (Misc queries) | |||
How do I autosum text? | Excel Worksheet Functions | |||
autosum ?? | Excel Worksheet Functions |