Previous chapterNext chapter Show allShow all    Hide allHide all

This function compares values in the stated area 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).

Syntax: =comparesum(condition area,sum reference,condition)

Example Example


Cell B2 to B11 are checked for =5. In the lines where this is true, the values of the cell are added to column A.