How to use BYCOL() and BYROW() to evaluate data across columns and rows ... Excel functions are autonomous—one result value for each function or formula. For example, you might use SUM() to ...

You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide ... to use the SUM function to total a column of data in which some of the rows are hidden ...

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows ... more than one column using the ...