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
Check out the Formula Handbook template!