#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
Set add function ignore #N/A 1
Excel Import Comments 3
#N/A Question 2
Access Help in formula? 1
Multiple Fxns in single sheet module 0
#N/A In Cells 7
Sum Function When Formula Produces #N/A 2

Top