Sum across rows

So I am trying to use a formula tool, I have columns like:

State City Locaiton Zip Location Revenue

CA Los Angeles 90012 100

CA San Francisco 94012 15

CA Los Angeles 90019 99

How can I use the formula tool to sum for City Location = Los Angeles? I am trying to get the revenue than organize by Zip location with city of Los Angeles only.

Thanks!

Developer Tools

Accepted answers

philipmannering

Hi @amandacastro

Is this what you're after? Total revenue for Los Angeles - see below,

total for LA.yxmd

All comments

philipmannering

Hi @amandacastro

Is this what you're after? Total revenue for Los Angeles - see below,

total for LA.yxmd

Qiu

@amandacastro
Hope this is what you need.

New Workflow1.yxmd

joshuaburkhow

@Qiu Just a friendly suggestion - you wouldn't want to do this (specifically filter in this case) in practice as its not scalable. If you look at what @PhilipMannering has done you will notice that if @amandacastro comes back with not just Los Angeles but maybe San Diego and San Francisco his solution still works with no changes!

A good rule to follow is to build workflows that can scale, more often then not they take the same amount of work 😉

Hope that helps!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703