microsoft excel courses - What is the sumif functions?

Hi Katherine, thanks for the post; the SUMIF function is used to total information in a list subject to certain criteria, for example from a list of sales branches, you can stipulate that you only require to total a particular branch's sales figures and using the SUMIF function it will return a total as per your criteria. The layout would be as follows: =SUMIF(range, criteria, sum_range) - which would be: (range of cells to inspect, criteria (name of branch in quotes " ") and the range of cells to find those totals in.
hope that helps
regards
Pete