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
Tags: #1minutecpd • ADD • count • Data literacy • Digital research and scholarship • excel • formula • IF • one minute cpd • sum • sumif • Timesavers