Combining Small&Large with Sum&Xlookup
Small & Large Rows & Columns This is an extension of this post: Small & Large & Row & Column I decided to embed within the Sum and Xlookup formulas the SMALL and LARGE function. I used it to find the sum of the 2 largest and smallest invoice amounts. I used the Xlookup to find the 2 smallest and largest invoice numbers this time.