Excel 2007 SUMIFS(): The accountant's favourite Excel function gets an overhaul. By Simon Hurst
SUMIF() is a very useful function for working with accounting data. As its name implies, it sums a range of cells if their contents, or the contents of an equivalent range of codes in another column, match a particular criteria.
You could use SUMIF() to sum all the values in a column that are above a particular value (in the examples, we have included the criteria data directly in the formula for simplicity – it would be much better design to include the criteria data in a separate cell and refer to the cell from the formula):