Sum several columns based on column headings.

there, no doubt, can be solutions far more elegant than this one. see attached.

there are a few caveats to this solution approach - tableau should be sorted such that "like" column labels are grouped together (A,A and E,E,E etc.); your Summary (Total) tableau should not be underneath your data tableau; assuming that all columns have equal number of rows of data.

EDIT: updated with another approach.

#1

Please Login or Register  to view this content.

#2

Please Login or Register  to view this content.

Hi

Thank you for your solution, but I forgot to mention that columns are in random orders and some columns need to be ingored.
I can not move the data as its in the correct format to upload.


A (A) A (A) B (B) D (D) J (J) D (D)
1 2 3 4 4 6 1 6 6 4 6 4
2 3 4 4 6 1 6 6 4 6 4 1
1 2 3 4 4 6 1 6 6 4 6 4
2 3 4 4 6 1 6 6 4 6 4 1
1 2 3 4 4 6 1 6 6 4 6 4
2 3 4 4 6 1 6 6 4 6 4 1


Total
A X
B X
D X
J X



Ignore all columns with brackets

Thnak you