Creating a Wedding Planner

In this video, a 10 minute clip taken from a webinar that I delivered in 2012, I build a spreadsheet that can be used by anyone planning a wedding. The video covers absolute cell references, SUMIF, COUNTIF and conditional formatting. I used Excel 2011 for Mac but...


The COUNTIF function is used to count the number of cells that contain a given value. The COUNTBLANK function counts the number of blank cells in a range. In this video I demonstrate how to use both functions in a spreadsheet that is used to organise a party

The SUMIF Function

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.