Sum of all values in a row based on column name

[arina]

I have this kind of excel. All values are stored as string. For all column name with “Amount *”, I need to sum all it and rewrite it to the “Total” column as the value inside it is no longer relevant.

Here’s attached the input data (mind the name):
Output.xlsx (11.8 KB)

[Yoichi]

Hi,

Hope the following sample helps you.

Sample20220726-2.zip (21.7 KB)

Regards,