# Decision matrix example in Excel

See how a decision matrix works in Excel: lay out options and criteria, apply weights with SUMPRODUCT, rank the scores and highlight the shortlist.

A decision matrix example in Excel shows how to score several options against weighted criteria so the comparison stays visible and repeatable. You list the options in rows and the criteria in columns, give each criterion a weight, and let spreadsheet formulas turn the entries into a single score per option. The page explains the layout, the formulas and the checks that keep the result honest. 

## Lay out options and criteria 

The template layout of a decision matrix puts each option in its own row and each criterion in its own column. A weight row sits above or beside the criteria so the numbers stay separate from the scores you enter. Keep one cell per judgment and label every row and column clearly, because unclear labels are the main reason a filled sheet gets misread later. Leave the total column empty until the formulas are in place. 

## Turn weights into one score 

The SUMPRODUCT weighted score multiplies each score by its matching weight and adds the results in one formula. You write it once in the first option row and copy it down, so every option is treated the same way. Weights should add up to a fixed total you choose, which keeps the scores comparable across options. If you change a weight, every score updates and you can see how much the ranking depends on that choice. 

## Rank and highlight the shortlist 

A rank formula sorts the weighted scores so the order of options is visible without manual sorting. Conditional formatting can then shade the top rows or flag scores below a threshold you set, which makes the shortlist easy to scan. Check for ties and for any criterion left blank, since an empty cell can distort a score quietly. Keep the raw scores visible next to the result so a reader can trace any number back to its source. 

## Questions About Excel Decision Matrices 

### What does a decision matrix example in Excel look like? 

A decision matrix example in Excel is a grid with options as rows, criteria as columns and a weight for each criterion. Scores fill the middle cells, and a formula combines them into one total per option. The sheet also holds a rank column and formatting that marks the leading options. 

### How does SUMPRODUCT calculate a weighted score? 

SUMPRODUCT calculates a weighted score by multiplying each score by its paired weight and summing all the products. You point it at the score row and the weight row, and it returns one number for that option. Copying the formula down gives every option the same treatment as the weights change. 

### Can conditional formatting show which options score highest? 

Conditional formatting can shade or mark the options whose weighted scores sit at the top of the ranking. You set a rule on the total column, such as a color scale or a threshold, and the sheet updates the marks when scores change. The formatting is a visual aid, so the underlying numbers stay the record. 

### What should the weights in the matrix add up to? 

The weights in an Excel decision matrix should add up to a total you fix in advance, such as one hundred or one. A fixed total keeps weighted scores comparable between options and between versions of the sheet. If the weights do not reach that total, the scores shift and the ranking can change for no real reason.
