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 ...
- Thanks Peter! However i don't think sumifs is appropriate as i got 50 columns 😞
- The catch with SUMIFS is that the array 'mask' must be of the same dimensions as the original table. That essentially doubles the memory committed to your data. On the other hand the '...IFS' functions execute very fast. The FILTER function is best but requires Excel 365, but then, traditional Excel couldn't hit the trash can fast enough for me; I dislike traditional spreadsheet practices intensely! Probably the nested SUM/IF is the most widely deployable technique.
A further note: my row array 'selectedColumns' comprised 0/1 flags to indicate whether the column is required or not.
