---
title: "Excel / spreadsheet calculation example"
slug: "scorecard/excel-spreadsheet-calculation-example"
section: "Scorecard"
description: "For scores in B2:B10 and weights in C2:C10, the weighted total is =SUMPRODUCT(B2:B10,C2:C10)/5 if weights total 100. Example ratings 4,3,4,5,4,3,4,3,5 yiel"
internal_only: false
---

# Excel / spreadsheet calculation example

For scores in B2:B10 and weights in C2:C10, the weighted total is `=SUMPRODUCT(B2:B10,C2:C10)/5` if weights total 100. Example ratings 4,3,4,5,4,3,4,3,5 yield **77/100** (illustrative; not a real supplier). Have two reviewers score independently, compare differences above one point, and request clarifying evidence.