How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel Naomi Gleit Mar 22, 2022 Image: iStockphoto Most Microsoft Excel functions are autonomous—one result value for each function or formula. For example, you might use SUM()…