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. \

Related Commands

See Also