# Adding multiple columns if one column equals X

Options

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

Tags:

## Answers

• ✭✭✭✭✭✭
Options

Try:

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

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• edited 03/01/21
Options

Thanks for the quick reply. Its still not working. I'm getting an "incorrect argument set"

• ✭✭✭✭✭✭
Options

I read your post again and I think I misunderstood. You want to sum each column if Alone =CN. Try this:

=SUMIF([\$ Regular]:[\$ Regular], Alone:Alone, "CN")+ SUMIF([\$\$ xyz 2021]:[\$\$ xyz 2021], Alone:Alone, "CN") +SUMIF([Per Item \$ 2021]:[Per Item \$ 2021],Alone:Alone, "CN") +SUMIF( [null 2021]:[null 2021], Alone:Alone, "CN") +SUMIF( [Revised \$\$]:[Revised \$\$ ], Alone:Alone, "CN")

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Options

I think we may be closer. I also think I may not be explaining properly.

If Alone=CN in that row, I want to add those numbers in each of those columns, and then add them all together into one number.

• ✭✭✭✭✭✭
Options

Using the columns in your last post, this should be the formula:

=SUMIF([two words]:[two words], Alone:Alone, "CN")+ SUMIF([one word]:[one word], Alone:Alone, "CN") +SUMIF([three words]:[three words],Alone:Alone, "CN") +SUMIF( [too many words]:[too many words], Alone:Alone, "CN")

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Options

Mark, thanks for all of your help! I must have something keyed wrong. I'm still getting an Unparseable error.

• ✭✭✭✭✭✭
Options

The syntax is off. You are using the SUMIFS syntax with a SUMIF function. Easiest way to fix this would be to add an S to the end of each function so that they are all SUMIFS.

• Options

Paul, thanks for the help. Still getting that dreaded error!

• ✭✭✭✭✭✭
Options

Make sure the column names match what are actually in your sheet.

=SUMIFS([two words]:[two words], Alone:Alone, "CN") + SUMIFS([one word]:[one word], Alone:Alone, "CN") + SUMIFS([three words]:[three words],Alone:Alone, "CN") + SUMIFS([too many words]:[too many words], Alone:Alone, "CN")

• ✭✭✭✭✭✭
Options

Thanks for the fix Paul.

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭
Options

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!