Suppose I have the following expression repeated in a long column:
=IF(OR($U2=""; COUNT(aHugeRange)=0); ""; SUM(aHugeRange))
I would like to avoid performing
SUM() as much as possible to increase performance.
SUM() be ever executed for the rows where $U is empty?
Will the following modification work differently?
=IF($U2=""; ""; IF(COUNT(aHugeRange)=0; ""; SUM(aHugeRange)))