Category : Lotus and other Spreadsheets
Archive   : SUMFUN.ZIP
Filename : SUMFUN.DOC

Here are some add in @functions that I created. I am releasing them for
the purpose of beta testing. If you have any problems or questions
concerning them, please let me know.
To load these type /T(ools) L(ibrary) L(oad)


Steve Devore

Compuserve: 71121,1717

6425 County Rd 30, #215
St. Bonifacius, MN 55375


---------------------------------------------------------------------------
N.QLL v1.0 by Steve Devore 8/3/92

N.QLL contains the following functions.

@N.ISBLANK(Block)
@N.COUNT(List)
@N.AVG(List)
@N.STD(List)

List = one or more blocks.

@N.COUNT, @N.AVG, AND @N.STD will ignore strings and blanks. If the
AVG or STD is performed on a blank range (or a range that contains only
strings), a null string is returned.

Single cell blocks must be entered as blocks; Qpro will not change a single
cell reference to a block. For example to find out if A1 is blank you must
type @N.ISBLANK(A1..A1) or @N.ISBLANK(!A1), but not @N.ISBLANK(A1).



---------------------------------------------------------------------------
SCAN.QLL v1.0 by Steve Devore 8/3/92

SCAN.QLL contains the following functions:

@SCAN.SUM(Block,ScanValue,Col)
@SCAN.COUNT(Block,ScanValue,Col)
@SCAN.AVG(Block,ScanValue,Col)
@SCAN.STD(Block,ScanValue,Col)

Block: The block to scan.
ScanValue : The value to match in the first column in the block.
Col: The column to add, count, etc.

These functions will search a given block's first column for all occurences
of ScanValue, then perform the desired operation on the cell at all the
rows that match. The Block does not need to be sorted.

If an average or standard deviation is performed on a blank range, a null
string is returned instead of ERR.
---------------------------------------------------------------------------