How to sum a column based off other columns

[CookiesCPA]

Hello,

I am trying to create a new column which sums my 3rd column if tax type is GF and DR and if the location is the same. 

How do I get this:

[fmvizcaino · Accepted solution]

Hi @CookiesCPA ,

To achieve that, one way is by using a filter tool for your tax type and then you use a summarize tool grouping by location and summing your activity value.

Let me know if that works for you.

Best,

Fernando Vizcaino

[CookiesCPA]

Thank you, this got me to where I needed!