#350 Use SumIF in Excel to add conditions to your additions!

As we’re seen in previous posts on Excel, Excel is full of nifty little tricks to help make our lives much easier. In this post we take a look at the SumIF function. This function enables you to set conditions on what you want to add together.

These conditions can come from another cell, for example you only want to add together salaries from participants who work full time or you can set conditions on the row you are counting, for example only adding together salaries over £20,000.

Featured Image: “Accounting” by jurek d. licenced under CC BY-NC 2.0

Read the full story by

Tags:

RELATED READS
6 Awesome AR apps for the classroom Educational Tech Career Days: Building on the Hour of Code Movement
We are updating our Privacy Policy, so please make sure you take a minute to review it. As of May 25, 2018 your continued use of our services will be subject to this new Privacy Policy.
Review Privacy Policy OK