SUMIF, COUNTIF, AVERAGEIF and their plural cousins let you calculate on only the rows that match your conditions. Pick a function, set criteria, and watch the matching bars light up while Excel’s exact formula and result build live.
| Row | Region | Rep | Category | Units | Amount |
|---|