SumMatch
within a set that add up to a target sum
Not only for accountants, planners or engineers...
Solving the most popular accounting reconciliation challenge,
...multiple solutions at a time.
Imagine you have a set of financial transactions or expenses, and you need to determine which combinations of these entries contribute to a particular budget or financial goal.
SumMatch will find combinations of numbers from your set that add up to your target sum.
Effortlessly deliver financial reconciliations, easily match payments to invoices and expenses to quotes.
Budgeting, resource allocation, engineering calculations, this number matching problem appears in many professional fields.
SumMatch can solve it for you, efficiently and accurately.
You can use SumMatch online - in your browser
YouTube video SumMatch online
...or alternatively use SumMatch Excel add-in (only Excel on Windows is supported).
YouTube video SumMatch online
SumMatch Excel Add-in is built on the VSTO platform.
If you intend to exclusively utilize the add-in and have no interest in SumMatch online, we recommend trying it out
before making a purchase. Please be aware that our support for desktop installations is limited.
SumMatch is designed to streamline number crunching. With SumMatch, users can effortlessly select a large number of cells from an Excel worksheet or a web grid and swiftly identify combinations of numbers that sum up to a specific target value. SumMatch can handle up to 500 input numbers. Here’s how it works:
- Selection: Users choose the relevant cells from their worksheet or web grid.
- Target Sum: Users enter the target sum in the input textbox.
- Combinations: SumMatch identifies all possible combinations of numbers from the selected input range that add up to the target sum.
- Solutions Panel: The solutions—these combinations—are neatly displayed in the solutions panel.
- Hyperlinks: Each solution is represented by a hyperlink.
- Highlighting: When users click on a solution hyperlink, the corresponding combination of cells is highlighted in the worksheet.
Get two products for the price of one.
Every subscription includes SumMatch online and SumMatch Excel add-in.
Use one of them or use both with no extra charge.
- Up to 500 numbers in set
- Unlimited time trial with limited functionality
- Runs in your browser or as an Excel add-in
- Excel add-in runs only in Windows os
- Up to 500 numbers in set
- Subscription paid annually
- Runs in your browser or as an Excel add-in
- Excel add-in runs only in Windows os
- Up to 500 numbers in set
- Subscription paid monthly
- Runs in your browser or as an Excel add-in
- Excel add-in runs only in Windows os
- Up to 500 numbers in set
- Unlimited time trial with limited functionality
- Runs in your browser or as an Excel add-in
- Excel add-in runs only in Windows os
- Up to 500 numbers in set
- Subscription paid annually
- Runs in your browser or as an Excel add-in
- Excel add-in runs only in Windows os
- Up to 500 numbers in set
- Subscription paid monthly
- Runs in your browser or as an Excel add-in
- Excel add-in runs only in Windows os
It may not be easy.
This deceptively simple problem is well-known in computer science as the subset sum problem.
Let's imagine you have 50 numbers in your set and you want to find combinations of these numbers that add up to your target sum.
How many sums you need to calculate?
You would have to calculate 250 = 1,125,899,906,842,624 sums.
It becomes obvious that we may like to use more efficient approaches.
We have done it for you - with SumMatch you can quickly solve most of your sum matching problems without effort.