Sum Sheet Area

Totals up all the numbers in a sheet area

Parameters

Spreadsheet: Sum from this sheet location [c,r] = [left,top]
Columns: number of columns in the area
Rows: Number of rows in the area
Returned Total: Global Data Item that receives the total


Comments

Call at any time (but most likely used for reporting on End Run)

==== Example ====

   Sum Sheet Area ss_WaitingTimes[1,2] , 5 , 10 , ss_WaitingTimes[1,1] 

Will sum from ss_waitingtimes[1,2] to ss_waiting times[5,12] and put the returned value in cell [1,1] of the same sheet. \

• Copy Sheet Area
• Copy Sheet Column
• Copy Sheet Row
• Count Sheet Area
• Count Sheet Area Non Zero
• Sum Sheet Area
• Search Sheet Area
• Clear Sheet
• Clear Sheet Area
• Clear Sheet Data Only
• Insert Row
• Insert Column
• Insert Cell Vertical
• Insert Cell Horizontal
• Delete Row
• Delete Column
• Delete Cell Vertical
• Delete Cell Horizontal

• Simul8 Spreadsheets