The array expression {=SUMif($C$2:$C$789=$C794;TRUE();$D$2:$D$789)} provides another workaround that looks rather lucid and can easily be adapted if needs change in details. The array expression {=SUMif($C$2:$C$789=$C794;TRUE();$D$2:$D$789)} {=SUMIF($C$2:$C$789=$C794;TRUE();$D$2:$D$789)} provides another workaround that looks rather lucid and can easily be adapted if needs change in details. The array expression {=SUMIF($C$2:$C$789=$C794;TRUE();$D$2:$D$789)} provides another workaround that looks rather lucid and can easily be adapted if needs change in details.
The array expression {=SUMIF($C$2:$C$789=$C794;TRUE();$D$2:$D$789)} provides another workaround in addition to those "mariosv" listed that looks rather lucid and can easily be adapted if needs change in details. Unfortunately we have a situation for the moment with the versions 4.x.y where filling array formula 'Down' is broken. The array expression {=SUMIF($C$2:$C$789=$C794;TRUE();$D$2:$D$789)} {=SUMIF($C$2:$C$789=$C794;TRUE();$D$2:$D\$789)} provides another workaround in addition to those "mariosv" listed that looks rather lucid and can easily be adapted if needs change in details.