Yes that is possible to do in Excel, I guess it would mean some nested IF's,
AND's, OR's and SUM functions... Other way that I think about is maybe the
value picked returns a value with a VLOOKUP, INDEX, MATCH, etc function and
then the sum of those for or so? depends what specifically want to do...