> Sumif is a simpler lookup Never used it in this way, but why not. To me, conditional sums are a replacement for filters and pivot tables, because they let y

> Sumif is a simpler lookup Never used it in this way, but why not. To me, conditional sums are a replacement for filters and pivot tables, because they let you have all the information in one go, without constantly clicking to select criteria. Just select unique values for criteria and do conditional sums for each of them, and you have a visual that shows you all possible combinations and results at the same time.