
Sum on range and Sum on Sum's

Status: Preliminary




Download and open the
testdocument
Place the cell cursor on the
gray cells located under Point 1. (Multiselection is not possible
at this place) and press the Sum Icon in the formula bar. Now hit
the enter key and the result should be shown. Do so for each gray
cell in this part of the document.
Compare the formula entered
with the one found next to each summation field
Compare the formula result for
all gray cells with the values found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Sum on Row and Column

Status: Preliminary




Download and open the
testdocument
Place the cell cursor on the
gray cells located under Point 2. (Multiselection is not possible
at this place) and press the Sum Icon in the formula bar. Now hit
the enter key and the result should be shown. Do so for each gray
cell in this part of the document.
Compare the formula entered
with the one found next to each summation field
Compare the formula result for
all gray cells with the values found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Subtotals on Autosum

Status: Preliminary




Download and open the
testdocument
Place the cell cursor on the
gray cell located under Point 3. and press the Sum Icon in the
formula bar. Now hit the enter key and the result should be
shown.
Compare the formula entered
with the one found next to the summation field
Compare the formula result with
the one found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Autosum on column with selected empty cell for result

Status: Preliminary




Download and open the
testdocument
Select the gray cells located
under Point 4. and press the Sum Icon in the formula bar. Now hit
the enter key and the result should be shown.
Compare the formula entered
with the one found next to the summation field
Compare the formula result with
the value found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Autosum on rows with selected empty cell for result

Status: Preliminary




Download and open the
testdocument
Select the gray cells located
under Point 5. and press the Sum Icon in the formula bar. Now hit
the enter key and the results should be shown.
Compare the formulas entered
with the ones found next to the summation fields
Compare the formula results
with the values found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Subtotal on column with selected empty cell for result

Status: Preliminary




Download and open the
testdocument
Select the gray cells located
under Point 6. and press the Sum Icon in the formula bar. Now hit
the enter key and the results should be shown.
Compare the formula entered
with the one found next to the summation field
Compare the formula result with
the value found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Autosum on column without selected empty cell for result

Status: Preliminary




Download and open the
testdocument
Select the gray cells located
under Point 7. and press the Sum Icon in the formula bar. Now hit
the enter key and the results should be shown.
Compare the formula entered
with the one found next to the summation field
Compare the formula result with
the value found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Autosum on rows without selected empty cell for result

Status: Preliminary




Download and open the
testdocument
Select the gray cells located
under Point 8. (you may use Multiselection with the CTRL key) and
press the Sum Icon in the formula bar. Now hit the enter key and
the results should be shown.
Compare the formulas entered
with the ones found next to the summation fields
Compare the formula results
with the values found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Subtotal on column without selected empty cell for result

Status: Preliminary




Download and open the
testdocument
Select the gray cells located
under Point 9. and press the Sum Icon in the formula bar. Now hit
the enter key and the result should be shown.
Compare the formula entered
with the one found next to the summation field
Compare the formula result with
the value found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Autosum on multiselected columns without selected empty cell
for result

Status: Preliminary




Download and open the
testdocument
Select the gray cells located
under Point 10. and press the Sum Icon in the formula bar. Now
hit the enter key and the results should be shown.
Compare the formulas entered
with the ones found next to the summation fields (a '/' is used
as a delimiter to show that this is for the first second or third
column)
Compare the formula results
with the values found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Autosum on columns with formula results without selected empty
cell for result

Status: Preliminary




Download and open the
testdocument
Select the gray cells located
under Point 11. and press the Sum Icon in the formula bar. Now
hit the enter key and the results should be shown.
Compare the formulas entered
with the ones found next to the summation fields (a '/' is used
as a delimiter to show that this is for the first second or third
column)
Compare the formula results
with the values found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Autosum on column with filled cell under selected area

Status: Preliminary




Download and open the
testdocument
Select the gray cells located
under Point 12. and press the Sum Icon in the formula bar. Now
hit the enter key and the results should be shown.
Compare the formulas entered
with the ones found next to the summation fields (a '/' is used
as a delimiter to show that this is for the first second or third
column)
Compare the formula results
with the values found in the 'Should be' Column
All findings correct ? No ? File an Issue.


Autosum on column and rows with empty cells selected for row
and column

Status: Preliminary




Download and open the
testdocument
Select the gray cells located
under Point 13. and press the Sum Icon in the formula bar. Now
hit the enter key and the results should be shown.
Compare the formulas entered
with the ones found next to the summation fields (a '/' is used
as a delimiter to show that this is for the first second or third
column)
Compare the formula results
with the values found in the 'Should be' Column
All findings correct ? No ? File an Issue.
