Sum columns based on column headers

[Klachner]

Can someone help me sum data in columns based on column header names. I've attached an excel example

[binu_acs]

@Klachner use the dynamic select tool to get the column total. You can use the sample workflow attached

[Klachner]

Thanks binuacs, is there a way to sum the jurisdiction by invoice number. attached an example.

[Raj]

@Klachner just Group by the invoice no in the summarize tool before calculating the sum

you will get the result required.

[binu_acs]

@Klachner 

[nagakavyasri]

@Klachner Another way: