Functions 8: SUMIF, COUNTIF & AVERAGEIF Time to learn: 30 minutes Do you need to get the breakdown of sums, averages or a count of your data? Need to get them by SEPARATE CATEGORIES? Needed it yesterday? This series of formulas has so many uses, it’s amazing. You’ll be able to get the sums, counts and averages of items by specifying criteria of your design! Let’s start with some data. Here we have a list of students, with the following columns – Name, Age, School, Grade and Fee. Now, let’s see what we can do. SUMIF/SUMIFS This function adds values together if they fulfil certain conditions that YOU specify! SUMIF will only add values based on 1 specified condition SUMIFS will add values based on more than 1 specified condition Here’s an example. Let’s try to find out how much in fees students from school X pay: =SUMIF(C:C,”X”,E:E) Like all formulas, begin with ‘=’ and then the function SUMIF, with the
excelpunks. Training - Consultancy - Solutions. 