comparesum |
|
Manual -> Report Generator -> Engineering in the Editor -> Report functions -> Other functions -> comparesum |
   Show
all  Hide
all |
comparesum |
|
Manual -> Report Generator -> Engineering in the Editor -> Report functions -> Other functions -> comparesum |
|
Show
all Hide
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)
|
|
|
=comparesum(B2:B11,A2,=5) 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. |
Example