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