SUM IF FORMULA

Question

Hello Everyone!

I have the below set of information (you'll find the full list on the "Input" file i'm attaching).

I'd need to convert everything into 2 new columns by "Entity Code" that perform a formula similar to a sumif, as follows:

* First new column: If the "Year" is "2017" and "Account Code" is "CFCFPTI2" and "Adjustment Type"  is "Transition Tax 965(a)", then sum the amounts in "FC Amount"
* Second new column: If the "Year" is "2017" and "Adjustment Type" is "E&P Original Record" and "Subpart F type" is "PTEP 965(a)-959(c)(2) or "PTEP 965(a)-959(c)(1)(A)" then sum the amounts in "FC Amount" Column

Please note these should be sorted by ENTITY, but Im attaching a "Desired output" file for you to see what i look for.

Thanks!

Desired Output.xlsx

Input.xlsx

echuong1 · Accepted Answer

A sumif can be replicated through a filter and a summarize tool. Essentially, you'll want to filter for the records you'd like to sum. After that, you can use a summarize tool with any sort of group bys for the sum.

See attached for an example.