I am needing a sub for A "SUMPRODUCT" formula I use in Excel.
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.
Help Article Resources
Check out the Formula Handbook template!