An alternative to using SUMPRODUCT is to manually enter a formula that multiplies each set of values and weights, sums those up, and then divides by the sum of weights. Another method could involve scripting in VBA (Visual Basic for Applications) to automate weighted average calculations where Excel's built-in functions are limited.