Doing so gives you individual values; using BYCOL() returns an array. The real power here is that you can substitute MAX() with just about any Excel function. For example, Figure B shows the sum ...

How to use the newish XLOOKUP() dynamic array function in Excel Your email has been sent ... You use these functions when you want to find values based on the value in a corresponding cell.