98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sum function
Sum function
Resolved · Low Priority · Version 2003
Fri 22 Aug 2008, 16:43Delegate Delicia said...
Delicia has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Access VBA course
Sum function
If the number of single cells (for example weekly figures) exceed the number of cells allowed in sum function. What is an alternative formula to use? A pivot table?
Wed 10 Sep 2008, 15:25Trainer Simon said...
RE: Sum function
Hi Delicia,
Thank you for your question.
There is no limit to the number of cells you can use in the sum function beyond the number of cells available in a worksheet which is 65536. You an specify up to 30 ranges of cells.
You can also use Pivot tables to show totals for row and columns headings you specify from your excel list.
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:Adding up rows or columns without seeing formulasHighlight a column or row and click the Autosum button. This gives you your answer without showing the formula. |
