98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Summing Columns
Summing Columns
Resolved · High Priority · Version 2003
Graham has attended:
Excel Intermediate course
Excel Advanced course
Summing Columns
I am trying to summ a column which has a mix of numbers and un resolved formulas. The unresolved formula cells show #N/A. The summed total cell also shows #N/A. How can I sum the full column taking into account the resolved cells with numbers and ignoring the unresolved formula cells.
Thanks in advance.
Graham Warren
RE: Summing Columns
Hi Graham,
Thank you for your question.
You can use the DSUM function to achieve this.
The first thing to do is copy the column headings of the ranges you are trying to sum to some blank cells.
Underneath the relevant column heading type <>#N/A. This is saying not equal to #N/A.
There are three arguments:
1. Database range, so all the cells in the column you are trying to sum including the heading.
2.Field argument is the cell that contains the column heading at the top of the data figures you are trying to sum.
3. The final argument is the criteria which is the copied heading and the criteria you typed underneath it.
I hope this answers your question.
Regards
Simon
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Return to the active cell after scrollingWhen I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen. |