Category Archives: Formulae explained

AVERAGE

Summary AVERAGE takes some legwork out of formula creation. It adds up some numeric cells and then divides this by the number of cells it added up. In mathematical jargon, it provides the arithmetic mean of a set of cells. … Continue reading →

SUM

Summary SUM is probably the most regularly used formula. It does exactly what it says on the tin. It adds things up. It only applies to cells that are formatted as numeric values (including dates, percentages etc. as well as … Continue reading →