Dec 08 2020 11:01 AM - edited Dec 08 2020 11:01 AM
Dec 08 2020 12:43 PM
SolutionThat could be
=SUM(XLOOKUP(O3,$C$2:$N$2,$C3:$N3):XLOOKUP(P3,$C$2:$N$2,$C3:$N3))
or
=SUM(INDEX(C4:N4,MATCH(O4,$C$2:$N$2,0)):INDEX(C4:N4,MATCH(P4,$C$2:$N$2,0)))
Dec 08 2020 11:36 PM
@JMB17 Please find attached the file.
Dec 08 2020 12:43 PM
SolutionThat could be
=SUM(XLOOKUP(O3,$C$2:$N$2,$C3:$N3):XLOOKUP(P3,$C$2:$N$2,$C3:$N3))
or
=SUM(INDEX(C4:N4,MATCH(O4,$C$2:$N$2,0)):INDEX(C4:N4,MATCH(P4,$C$2:$N$2,0)))