Ever needed to add up numbers on your Excel spreadsheet that meet a certain criteria – E.G. only numbers above a certain value. Excel’s SUMIF function will allow you to total up numbers in range that meet the criteria that you set using the SUMIF function. Click on the link below to open a short PDF guide showing the steps needed to do this (posted by Chris James on 25/09/2015)
Excel has dozens of keyboard shortcuts that can be used to safe time – we have produced a short video (below) with 3 or 4 not so well known ones that we find saves us time day-today.