I know that Excel has a way to search a range of numbers and try all
possible combinations in that range to see if any of the numbers in the
range equal a specified total. For example (a very simple example),
column A, with the numbers 102, 209, 315, 483 and 562. How do we get
Excel to search column A for the combination of cells that would equal
524?

I also know this requires solver, but am unsure of how to manipulate
solver to perform this task. Any tips would be greatly appreciated.