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

Sum function

ResolvedVersion 2003

Fri 22 Aug 2008, 16:43 Delegate 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:25 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips

Sum function

Sum function

RE: Sum function

Excel articles

Excel tip:

Stop Formula Returning A "#DIV/0" Error