As well as using Excel's logical functions, I use various other combinations of functions to evaluate and use data in Excel's tables, such as INDEX with MATCH, and COUNTIF with SUM.