SumProduct formula



i have task in smartsheet and each task i give factor which amounts 100%.

and each task i give actual % complate.

the problam is when i try to calculate the Weighted average i need to multiply each task in his factor.

if i delete or adding 10 to 50 tasks its Becomes exhausting

in excel its easy by using formula SUMPRODUCT.

any idea to resolve ?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!