The SUMIF function is used to add up the figures in a range of cells but only for those cells that match a criteria. In this example I show you how to use the SUMIF function to calculate how much the employees will contribute towards the office Christmas party.
