Hi,
To calculate a weighted average in Excel from multiple columns of grades and weights, you can use a straightforward formula. Let’s say your grades are in columns B, D, F, etc., and weights are in columns C, E, G, etc. Here’s what you do: in a new cell where you want the average, type =SUMPRODUCT(B2:F2, C2:G2) / SUM(C2:G2). This formula works by multiplying each grade by its corresponding weight across the columns, summing them up, and dividing by the total sum of weights. If there are empty cells in the weights column that you want to ignore, modify the formula like this: =SUMPRODUCT(B2:F2 * (C2:G2 <> "") * C2:G2) / SUM(C2:G2 * (C2:G2 <> "")). This ensures you get an accurate weighted average even with missing data. Adjust the cell references (like B2:F2 and C2:G2) to match your actual data layout, and you’re good to go!

Jack