9-5-4

S SHT Mode Commands

uCellSum(

Function: Returns the sum of the values contained in the range of specified cells.

Syntax: CellSum( start cell : end cell [ ) ]

Example: To determine the sum of the values in the block whose upper left corner is located at A3 and whose lower right corner is located at C5, and input the result in cell A1:

uCellProd(

Function: Returns the product of the values contained in the range of specified cells.

Syntax: CellProd( start cell : end cell [ ) ]

Example: To determine the product of the values in cells B3 through B5, and input the result in cell A1:

20070201