With all that Microsoft Excel has to offer legal professionals, it can be overwhelming and intimidating to even get started. A few simple steps, though, will make quick calculations easy and increase your team’s productivity.
Check out this quick video tip about how Excel’s SUMIF functions allow you to get a handle on your data from the Affinity Insight live training sessions on the Excel Function Series.
Excel's SUMIF function allows you to quickly calculate subtotals. Start by clicking in the cell where you want to the subtotal. Then, click on the Math & Trig dropdown on the Formulas ribbon. Select SUMIF.
For the range, enter the range of cells you want to evaluate. For the criteria, enter what the cells in the range must be equal to in order to be included in the subtotal. Finally, for the sum range, enter the range of cells to be totaled.
Don't miss another live training session- subscribe here!
If you are interested in more training videos, or if you're ready to create a culture of training in your organization, discover all that Affinity Insight has to offer. Or, if you have any questions about Microsoft Excel, SUMIF and other functions, or Affinity Insight, contact us at 877-676-5492, or request a consultation. Our team of experts is ready to help!