Solver and Goal Seek for Google Sheets™. Free, with no limit on the number of cells.
Install it, then open Extensions → Sheet Solver → Open Solver. Click Insert example and you see it work in under a minute.

Does Google Sheets™ have a Solver? Not built in. Sheet Solver adds the one you know from Excel: pick a goal cell, choose Max, Min or a target value, pick the cells it may change, add your limits, and click Solve. The best answer is written straight into your sheet.

Does Google Sheets™ have Goal Seek? Now it does. Choose the formula cell, the value you want, and the input cell to change. Goal Seek finds it in a few tries, usually in seconds, and you can undo with one click. It works on loans, prices, margins, break-even and any other formula.

What people use it for
- Spend a budget where it gives the most: projects, marketing, stock.
- Product mix and production plans: the most profit within machine hours and materials.
- Staff and shift plans: cover every shift at the lowest cost.
- Pick the best team: the highest score within a budget and squad rules, for fantasy cycling, football and other games.
- Homework and courses in linear optimization and what-if analysis.

Your limits, your way
Limits can be ≤, ≥ or =, against a number or a cell. Cells can be whole numbers or yes/no (0 or 1). Each tab keeps its own model, and the model travels with the spreadsheet when you make a copy.

Fast with normal formulas
Sheet Solver reads SUM, SUMPRODUCT, SUMIF and SUMIFS directly, so a model with 300 changing cells solves in under 20 seconds. Other formulas work too; they are measured cell by cell, which takes longer.

Only the spreadsheet you have open
Sheet Solver only gets access to the spreadsheet you are working in, plus permission to show its sidebar. It cannot open your other files, it does not read your email, and your numbers never leave your browser and Google.

Coming from Excel's Solver?
The same three boxes, the same idea: objective cell, changing cells, constraints. If Solver or Goal Seek is not working for you in Google Sheets™ today, try the example first and then copy your own model in.

Free
- Solver with no size limit
- Goal Seek with no limit
- Always pick / never pick cells
- 3 tries of every Pro feature each month

Pro: $4.99 a month or $39 a year
- Up to 51 solutions in one solve, the best first, each different from the others, with a cap on how often one pick may repeat. Listed on their own tab.
- Solve every tab with a model in one click.
- Safe and High ceiling strategies for picking teams that hold up on a bad day or aim for a big win.
- Next-season projections from past seasons.
Cancel any time. The Solver itself stays free.

Support
Write to contact@addonnordic.dk. We answer on weekdays.

Sheet Solver is made by AddonNordic ApS, Denmark (CVR 46495985).

Google Sheets™ is a trademark of Google LLC. Excel is a trademark of Microsoft Corporation. Sheet Solver is not affiliated with or endorsed by Google or Microsoft.