Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.

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)} 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.

Unfortunately we have a situation for the moment with the versions 4.x.y where filling array formula 'Down' is broken.