comparespsum

This function compares values in the stated area in a special format with a condition and returns the sum of the hits from a reference area.

As a help for the definition this function can be selected from the menu entry Format/Functions (or with the right mouse button on the cell).

Parameter:

Start cell	Cell with the first value
direction	"right" or "bottom"
P1	Number of values in the first row
P2	Empty cells between two value outputs
P3	Empty cells until the next value row
P4	Maximal number of values to compare
condition	condition

Syntax: =comparespsum(Start cell,direction,P1,P2,P3,P4,condition)

Example

=comparesp(A1,"bottom",12,0,0,12,"=5")