SUMPRODUCT - Need help

JeromeRoquette

Hello all,

I'm looking for finding a workaround of the excel function SUMPRODUCT

Below an example : Where you can see 16% the formula is :

=SUMPRODUCT(F14:F46,E14:E46)/SUM(E14:E46)

In advance thanks

Georgie

Hi @JeromeRoquette,

As Smartsheet doesn’t currently have the SUMPRODUCT function, I’d recommend adding your vote to this product idea: Please Add a Sum Product Formula -  you’ll then receive updates when the status of the idea changes! 

However, you may be able to use the SUMIF or SUMIFS functions in Smartsheet as an alternative - SUMIF adds numbers within a range that meet a specified condition, and SUMIFS adds numbers within a range when all given conditions in their respective ranges are met. Take a look below for more information:

• SUMIF Function
• SUMIFS Function

You might also find the following related threads here in Community helpful, as other members have provided their suggestions for alternative solutions for SUMPRODUCT:

• Converting =SUMPRODUCT from Excel to Smartsheet
• Is there a Way to Emulate SUMPRODUCT In Smartsheet With a Cross Sheet Reference?
• I am needing a sub for A "SUMPRODUCT" formula I use in Excel.

Hope that helps!

Georgie