I have a table with repeated ID numbers and a different cost for each ID number. How could I get the total cost for an ID number? I can accomplish this in Excel using a SUMIF formula, but was wondering if this can be done in ArcGIS Pro directly? For example, see table below.
| A | B | C | D |
| ID | Cost | Total Cost by ID | Excel "SUMIF" formula |
| 1 | $11,040.00 | $11,040.00 | SUMIF(A:A,A2,B:B) |
| 3.5 | $39,140.00 | $1,232,015.00 | SUMIF(A:A,A3,B:B) |
| 3.5 | $160,286.00 | $1,232,015.00 | SUMIF(A:A,A4,B:B) |
| 3.5 | $97,440.00 | $1,232,015.00 | SUMIF(A:A,A5,B:B) |
| 3.5 | $85,260.00 | $1,232,015.00 | SUMIF(A:A,A6,B:B) |
| 3.5 | $849,889.00 | $1,232,015.00 | SUMIF(A:A,A7,B:B) |
