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

sum function

ResolvedVersion 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:

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.