Excel Forum
Similar Content
Filter Data in Excel Without the Filter "Arrow" Appearing in the Filtered Column - AutoFilter
Macro: This Excel macro filters data in Excel without the filter "arrow" appearing in the column ...
Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel
Tutorial: How to Sum values using an OR condition across multiple columns, including using OR with ...
Highlight Rows that Meet a Certain Condition in Excel
Tutorial: In this tutorial I am going to cover how to highlight rows that meet a certain condition. ...



Excel Magic Trick 297.5: Conditional Sum for Varying Columns


Learn with formula is best from amongst five different formulas for conditionally summing from varying columns:
1.OFFSET formula
2.INDIRECT formula
3.SUMPRODUCT with multiplication and different sized ranges
4.SUMPRODUCT and INDEX function
5.SUMIFS and INDEX function.
We will see that the versions that use INDIRECT with a zero in the row_num are fastest in calculating.

Also see how data that is setup as a table / list / database is easier to analyze that data that is not in a database setup.





Got a Question? Ask it Here in the Forum.