How can I sum cells that include the abbreviation of states, but include commas in between?

haley brianne

As of right now I am summing selected cells, which then gives me everything that is in those cells. It is then merging them together, but I need it to include a comma if there is more than 1 cell that has information in it.

Paul Newcome

Try this instead:

=JOIN(COLLECT([Dash Columns]12:[Dash Columns]61, [Dash Columns]12:[Dash Columns]61, @cell <> ""), ", ")

Eric Law

@haley brianne Your screenshot is not really showing a lot. Can you recapture the screen shot and also give an example of what you want?

haley brianne

There should be a comma in between ME & DE. Those are abbreviations of states. @Eric Law

Paul Newcome

Can you provide the entire formula you are using?

haley brianne

=[Dash Columns]61 + [Dash Columns]60 + [Dash Columns]59 + [Dash Columns]58 + [Dash Columns]57 + [Dash Columns]56 + [Dash Columns]55 + [Dash Columns]54 + [Dash Columns]53 + [Dash Columns]52 + [Dash Columns]51 + [Dash Columns]50 + [Dash Columns]49 + [Dash Columns]48 + [Dash Columns]47 + [Dash Columns]46 + [Dash Columns]45 + [Dash Columns]44 + [Dash Columns]43 + [Dash Columns]42 + [Dash Columns]41 + [Dash Columns]40 + [Dash Columns]39 + [Dash Columns]37 + [Dash Columns]38 + [Dash Columns]36 + [Dash Columns]35 + [Dash Columns]34 + [Dash Columns]33 + [Dash Columns]32 + [Dash Columns]31 + [Dash Columns]30 + [Dash Columns]29 + [Dash Columns]28 + [Dash Columns]27 + [Dash Columns]26 + [Dash Columns]25 + [Dash Columns]23 + [Dash Columns]24 + [Dash Columns]22 + [Dash Columns]21 + [Dash Columns]20 + [Dash Columns]19 + [Dash Columns]18 + [Dash Columns]17 + [Dash Columns]16 + [Dash Columns]15 + [Dash Columns]14 + [Dash Columns]13 + [Dash Columns]12 @Paul Newcome

Paul Newcome

Try this instead:

=JOIN(COLLECT([Dash Columns]12:[Dash Columns]61, [Dash Columns]12:[Dash Columns]61, @cell <> ""), ", ")

haley brianne

Perfect, thank you @Paul Newcome !

Paul Newcome

Happy to help. 👍️