Sum up specific rows

[BosKev]

Hi All,

I'm looking for a formula or tool that can sum up rows depend on a condition.

example below I want to sum up market C and D and have the new sales be the total of the 2 markets, any suggestions? Thanks.

Market	Sales	New Sales
A	274	274
B	300	300
C	486	848
D	362	848
E	493	493
F	193	193

[Aaron_Harter · Accepted solution]

Hi @BosKev,

Consider using a Join to separate these data points into a new stream, then map them back into the table once the "New Sales" are calculated:

 

[BosKev]

Very creative, thank you!