Hi - I'm trying to work out if there is a way to use the FILTER function and SUM, to have both criteria along rows and columns.
Example formula below (yellow cell in image), with the first two criteria in the FILTER formula being on columns.... whilst the third criteria is along a row.
=SUM( FILTER( $C$4:$E$13,
($A$4:$A$13=$G5) * ($B$4:$B$13=J$4) * ($C$3:$E$3=$H5),0))
The alternative is to use the FILTER function on only columns, but I'd need a different formula for each cost, realisation and book value line.
I can't work out how to easily attach this file to my post, so have attached this image.
Example formula below (yellow cell in image), with the first two criteria in the FILTER formula being on columns.... whilst the third criteria is along a row.
=SUM( FILTER( $C$4:$E$13,
($A$4:$A$13=$G5) * ($B$4:$B$13=J$4) * ($C$3:$E$3=$H5),0))
The alternative is to use the FILTER function on only columns, but I'd need a different formula for each cost, realisation and book value line.
I can't work out how to easily attach this file to my post, so have attached this image.