Forum Discussion
Sum up list of selected columns
Hi all, Is there any way that allows to sum up all selected columns based on row? My main source is a report that contains 100++ columns and 1000++ rows, but I only want to sum up the selected ...
TheRuster Hi Ruster, may refer the table below 🙂
I got 10 columns, and I only want to sum up 4 columns for each staff.
The basic sum or index match will do but as in my original post, I got more than 50 columns that need to be sum up at last.
Not sure if there is any faster way for this. 😞
SookChing , you don't need 50 MATCHs, it could be as
=SUM(INDEX(range,ROW()-ROW($B$2),{1,4,7,8}))and drag it down. Or, if you have list of columns to sum
=SUM(INDEX(range,ROW()-ROW($B$2),XMATCH(columnNames, headers))