Adding multiple columns if one column equals X


I have a multi column sheet. If column Alone= CN, I want to total four columns.

=SUMIF([$ Regular]:[$ Regular], [$$ xyz 2021]:[$$ xyz 2021], [Per Item $ 2021]:[Per Item $ 2021], [null 2021]:[null 2021], [Revised $$]:[Revised $$ ], (Alone:Alone, CONTAINS("CN", @cell))

I've tried ever iteration and I cannot figure it out. Any help is greatly appreciated


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!