[FAQ000116]How can I exclude cells with formulas set in the cross tabulation?

Q

Using the "Cross aggregate sheet data" action,

How can I exclude cells with formulas set from the aggregation?

A

The following methods are possible.

・Set only the values (formulas) to be aggregated to the cells within the specified range of the cross tabulation

・Clear the values of cells within the specified range of the cross tabulation that are not to be aggregated

* In the CELF cross tabulation, if a value (formula) is set in a cell, even if the result is blank,

it will be included in the tabulation.