Prev: proper formula or function
Next: Array Formula + Indirect Reference
From: Betty K on 14 Dec 2009 20:53
I so much appreciate having this type of help available as I struggle to
learn more about formulas. Thank you to all.

Now, in Excel 2007, I have column U that returns a number, but in some cases
returns a "NA" (for "not applicable"). I need to add columns U+V+W+X, but
need to have the formula ignore the "NA" and just add V+W+X in those rows
where it appears.
From: T. Valko on 14 Dec 2009 21:02
Use the SUM function, it will ignore text entries:

=SUM(U1:X1)

--
Biff
Microsoft Excel MVP


"Betty K" <BettyK(a)discussions.microsoft.com> wrote in message
news:06E24E4D-3804-4CF3-9475-07519A6F958A(a)microsoft.com...
>I so much appreciate having this type of help available as I struggle to
> learn more about formulas. Thank you to all.
>
> Now, in Excel 2007, I have column U that returns a number, but in some
> cases
> returns a "NA" (for "not applicable"). I need to add columns U+V+W+X, but
> need to have the formula ignore the "NA" and just add V+W+X in those rows
> where it appears.


 | 
Pages: 1
Prev: proper formula or function
Next: Array Formula + Indirect Reference