SUMIF function
Excel » Functions » Math and trigonometry » SUMIF function »
To extract groups from cell range B3:B10 I use the following regular formula in cell B13.
The SUMIF function sums values based on a condition. The condition can be applied to the values being summed or […]
This article demonstrates a formula that calculates a running total. A running total is a sum that adds new numbers […]
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 […]