#N/A errors

L

Loren Newton

I am trying to sum a colume that has some cells with '#N/A'. The cell with
the total, displays a '#N/A' now. How can I have that cell display the total
of the numbers entered when there are the errors in the sumed cells. Thanks.
 
J

John Spencer

It seems that the field is a text field, so you should be able to use the
following in a query to get a sum. THe expression should also work in a
report or on a form.

Sum(Val([Some Field] & ""))

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 

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

#N/A error messages 2
Excel does not accept text format! 0
Need Help with a VBA subroutine 0
Formatting question: how to format duration (time spent)? 0
Summing totals in columns where some cells have error values 1
Remove Identical words 0
Copy addition formula of non-consecutive horizontal cells 2
Would like to input 3 letters into a cell, each having a different numerical value 5

Top