Let us see the spreadsheet. In column B we see 3 separate job positions. Now someone wants to know the total sum of Developers salary per year. How will you do that? The solution is simple. You can use the SUMIF function to do the task. =sumif(range of criteria, "criteria", sum range) Here, the fields are described by, Range of criteria used = job column (B:B) Criteria = "developer" (use quotes!) Sum range = Range which we want to sum (our salaries per year). Your task: Choose Analyst as the job position and calculate the total sum of salaries per year and then click "Check my Work".