I have a column of numbers which I am exporting to a spreadsheet (lets say it's A1:A100) and I need to find a subset of them that sum to a certain total. I can do this in Excel using the solver function but I am certain I should be able to do this within Filemaker 17 without having to export. Can anybody help me with this?

There are multiple options in filemaker that can produce such totals. A more detailed description of how your data is organized into fields and tables plus how you want to present these totals to the user would help us sort thru the options.