If Function = Add cell totals when criteria is met

%3CLINGO-SUB%20id%3D%22lingo-sub-2844536%22%20slang%3D%22en-US%22%3EIf%20Function%20%3D%20Add%20cell%20totals%20when%20criteria%20is%20met%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2844536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20am%20using%20the%20IF%20function%20in%20Smartsheet%2C%20format%20is%20just%20a%20bit%20different%2C%20example%20below%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20reference%204%20%22Date%22%20columns%3A%20Ship%20Month%2C%20Deposit%20Month%2C%20Install%20Month%2C%20Other%20Month%20-%20if%20the%20criteria%20is%20met%20(Ship%20Month%3D%202021-10)%2C%20then%20I%20need%20to%20Sum%20the%20respective%20Revenue%20columns%3A%20Shipment%20Rev%2C%20Deposit%20Rev%2C%20Install%20Rev%20and%20Other%20Rev.%20The%20formula%20below%20does%20return%20a%20value%2C%20but%20it%20is%20only%20the%20first%20value%20where%20criteria%20is%20found.%20Is%20there%20any%20way%20to%20sum%20all%20Revenue%20items%20that%20meet%20the%20%222021-10%22%20criteria%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIF(%5BShip%20Month%5D%40row%20%3D%20%222021-10%22%2C%20%5BShipment%20Rev%5D%40row%2C%20IF(%5BDeposit%20Month%5D%40row%20%3D%20%222021-10%22%2C%20%5BDeposit%20Rev%5D%40row%2C%20IF(%5BInstall%20Month%5D%40row%20%3D%20%222021-10%22%2C%20%5BInstall%20Rev%5D%40row%2C%20IF(%5BOther%20Month%5D%40row%20%3D%20%222021-10%22%2C%20%5BOther%20Revenue%5D%40row%2C%20))))%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2844536%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2844560%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Function%20%3D%20Add%20cell%20totals%20when%20criteria%20is%20met%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2844560%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1185110%22%20target%3D%22_blank%22%3E%40happy2belisac%3C%2FA%3E%26nbsp%3BI%20believe%20you%20can%20use%20SUMIF%2C%20demonstrated%20in%20the%20example%20attached.%20It%20may%20or%20may%20not%20resemble%20your%20actual%20situation%2C%20but%20hopefully%20it%20will%20put%20you%20into%20the%20right%20direction.%20If%20not%2C%20better%20to%20upload%20a%20file%20that%20does%20reflect%20the%20actual%20table%20you%20are%20working%20with.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Visitor

I am using the IF function in Smartsheet, format is just a bit different, example below:

 

I reference 4 "Date" columns: Ship Month, Deposit Month, Install Month, Other Month - if the criteria is met (Ship Month= 2021-10), then I need to Sum the respective Revenue columns: Shipment Rev, Deposit Rev, Install Rev and Other Rev. The formula below does return a value, but it is only the first value where criteria is found. Is there any way to sum all Revenue items that meet the "2021-10" criteria?

 

=IF([Ship Month]@row = "2021-10", [Shipment Rev]@row, IF([Deposit Month]@row = "2021-10", [Deposit Rev]@row, IF([Install Month]@row = "2021-10", [Install Rev]@row, IF([Other Month]@row = "2021-10", [Other Revenue]@row, ))))

1 Reply

@happy2belisac I believe you can use SUMIF, demonstrated in the example attached. It may or may not resemble your actual situation, but hopefully it will put you into the right direction. If not, better to upload a file that does reflect the actual table you are working with.