NA# - help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does any one know how have a sum ignore your fields with NA withouht changing all N/A's.
 
If the data you want to SUM is in B2,B3 and B4. Then enter the following
array formula. Do not type the { } brackets when entering the formula.
After typing in the formula press the Ctr&Shift and Enter this will add
the { } and make it an array..

{=SUM(IF(ISERROR(B2:B4),"",B2:B4))}

Charlie O'Neill
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AVERAGEIFS with multiple logical arguments for a range 1
Excel Named Ranges and Conditional Format 3
Removing #N/A from an "If/Then" statement 4
Data Validation List (conditional) 2
test for #NA , help please 2
Text Field Access 2003 2
Sum data range containing NA() 1
Word Using the 'IF' Formula in MS Word 2010 0

Back
Top