comparespsum

Previous chapterNext chapter Show allShow all    Hide allHide all

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 Example

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