SUMIF function

Excel » Functions » Math and trigonometry » SUMIF function »

Sum by group

To extract groups from cell range B3:B10 I use the following regular formula in cell B13.

How to use the SUMIF function

The SUMIF function sums values based on a condition. The condition can be applied to the values being summed or […]

How to create running totals

This article demonstrates a formula that calculates a running total. A running total is a sum that adds new numbers […]

Split expenses calculator

This article demonstrates two ways to calculate expenses evenly split across multiple people. The first one is a formula solution, […]

Extract unique distinct values sorted based on sum of adjacent values

Filtering unique distinct text values and sort them based on the sum of adjacent values can easily be done by […]