How to quickly calculate

In L3:
=SUMPRODUCT(($C$2:$C$6=$L$1)*($B$2:$B$6>=-(-LEFT($K3,2)))*($B$2:$B$6<=-(-RIGHT($K3,2))))
In M3:
=SUMPRODUCT(($C$2:$C$6=$L$1)*($B$2:$B$6>=-(-LEFT($K3,2)))*($B$2:$B$6<=-(-RIGHT($K3,2))),($D$2:$D$6))
In N3:
=SUMPRODUCT(($C$2:$C$6=$N$1)*($B$2:$B$6>=-(-LEFT($K3,2)))*($B$2:$B$6<=-(-RIGHT($K3,2))))
In O3:
=SUMPRODUCT(($C$2:$C$6=$N$1)*($B$2:$B$6>=-(-LEFT($K3,2)))*($B$2:$B$6<=-(-RIGHT($K3,2))),($D$2:$D$6))
Copy down to K6. Adjust the '6' in $B$6, $C$6, & $D$6 to suit whatever your last data row is.

Simply changing the age ranges in column K or adding new age ranges and copying the formulae down will result in an updated set of calculations.

Hi 302,

like this, see attachment:

Please Login or Register  to view this content.

BR, Alexandra

Avoid sheet interaction as much as possible.

Please Login or Register  to view this content.

You're welcome and thanks for rep+.