Converting =SUMPRODUCT from Excel to Smartsheet

Options
Katrina
Katrina ✭✭✭✭
edited 06/15/23 in Formulas and Functions

How would I convert this formula to work in Smartsheet?

=SUMPRODUCT(($B$93:$B$137=$A144)*(J$93:J$137)*(1-($G$93:$G$137)))

B93-B137 = Project Type

J93-J137 = [July thru 7/31]$125


I can get the first part using a SUMIF formula: =SUMIF([Project Type]$83:[Project Type]$125, =$[Project Type]@row, [July thru 7/31]$83:[July thru 7/31]$125)

The last Part *(1-($G$93:$G$137) is what stumps me. I need it to calculate the difference of a percentage listed in the cell.

Not sure if this can be done in one formula, or if it will require a helper sheet.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!