I am needing a sub for A "SUMPRODUCT" formula I use in Excel.

Options

I have costs and associated QTY's hosted in a separate sheet. The "A*B=Total" column I just added here to help explain what the "=SUMPRODUCT(A4:A10,B4:B10)" formula nested in E3 is performing. I could easily add additional columns in my smartsheet and then just run a formula to total the columns but I was trying to keep from adding additional columns to the sheet if possible. I have several of these formulas to run, so adding 4 additional columns to execute isn't optimal. Hoping this is an easy one.



Answers

  • Genevieve P.
    Options

    Hi @SUPERSONICERIC

    Smartsheet doesn't currently have a SUMPRODUCT function, so what you're describing here (additional columns to create your total values) is actually what I'd suggest.

    If you apply the "A*B=Total" as a Column Formula you then won't have to worry about it after the initial set up. You could then create a Report based off this sheet to create your overall totals, or a cross-sheet formula.

    Please let the Product team know of your request and feedback by filling in this form, here!

    Thanks,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!