Tag Archives: SUM

SUMPRODUCTIF

I recently found out how to do the equivalent of a SUMPRODUCTIF, a formula that doesn't exist in Excel. Here’s the detail on how. First of all, some context. SUM does exactly what it says on the tin. It sums … Continue reading →

Correct syntax for formulae

I think way back when, some highly-read source must have mistakenly advised people that to create a basic arithmetic formula, you needed the SUM, irrespective of the calculation being performed. So I often see formulae such as: =SUM(C7-C6) If you're … Continue reading →

Killer Sudoku Pro: spreadsheet helper

Challenge: There is a variant of Sudoku called Killer Sudoku in which areas of the grid, either square, rectangular or some other irregular shape, are caged off. A small number in the corner indicates the value to which the numbers … Continue reading →