'SUMIF function' category



Sum by group
To extract groups from cell range B3:B10 I use the following regular formula in cell B13. =LOOKUP(2,1/(COUNTIF($B$12:B12,$B$3:$B$10)=0),$B$3:$B$10) Copy 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, […]
Lookups in relational tables
Excel 2010 has a PowerPivot feature and DAX formulas that let you work with multiple tables of data. You can […]
Extract unique distinct values sorted based on sum of adjacent values
Filtering unique distinct text values and sorting them based on the sum of adjacent values can easily be done by […]

Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values

Excel categories