A common task when using excel is to sum the values in a column B where the contents of a neighboring column A is a certain value.
Take the following excel grid which lists the number of fruit sold on a given date by type. How would we go about getting a count of all the apples sold only.
This can be accomplished using the SUMIF function which takes three arguments:
To get a sum of all apples sold we search cells B2 -> B7 for the string "Apple" and sum the values in the neighboring cells C2 -> C7 where we find a match.