Help - SUMIFS issue Excel vs Smartsheet


I have this basic SUMIFS in Excel but cannot seem to replicate it within Smartsheet?


Range F10:F12 are figures related to commission, Range G10:G12 are names of items that are already listed in a different column (D). Column E is an amount already in the sheet

I'm looking for this formula to automatically do a sum based on 2 results manually entered in other cells.

The formula seems different in Smartsheet and is asking for a Criterion1 which I don't seem to need in Excel?

Any help appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!