To sum a Column in a Microsoft Excel spreadsheet, you can use the AutoSum, the Status Bar, and even the Sum function to calculate values in one or more columns ...

Figure E Use Excel’s BYROW () to evaluate by rows. As with Excel’s BYCOL (), you could do this with several MAX () functions, but that would require 11 functions and would return 11 result values.