COUNTIF

The COUNTIF Function This quick video explains how you use The COUNTIF Function in Excel. Learn how to use the COUNTIF function to count entries in a range of cells that meet certain criteria (e.g. values over a certain amount). Useful function to use when trying to...

How to use the SUMIF Function in Excel

How to use the SUMIF Function in Excel This quick video explains how to work with the SUMIF formula in Excel. Learn how to work with the SUMIF formula to add up values in a range of cells only if a matching cell meets a certain criteria (particular sales person,...

IF Statement

IF Statement This quick video explains The IF Statement in Excel. Learn to use the IF statement – widely used in Excel when testing for a particular condition (is commission payable? Is it a Monday?) Learn when to use this function and understand when it is used....