Hi everyone, I'm relatively new to Excel and managing to learn lots by reading and watching YouTube clips etc.

I got thinking to an old Fantasy F1 league I used to be in, and the guy used to be able to compute what the most optimal team was (using previous results from races), and I was just wondering if anyone knew what function this might be so I can read into it more?

For context, it was something like you can spend a maximum of $40m, and had to choose 2 drivers, a chassis, an engine, and 1 $1m driver (only loses points).

I've seen solver, but I don't know how you would use that to pick from multiple differentcategories, but have a cap of $40m? I can't imagine it was done manually each race

Sample_Excel_Help.png