sum function

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sum function

Sum function

resolvedResolved · Low Priority · Version 2003

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?

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


 

Excel tip:

Adding up rows or columns without seeing formulas

Highlight a column or row and click the Autosum button. This gives you your answer without showing the formula.

View all Excel hints and tips


Server loaded in 0.09 secs.