'SUMIF function' category
How to use the SUMIF function
What is the SUMIF function? The SUMIF function sums values based on a condition. The condition can be applied to […]
What is the SUMIF function? The SUMIF function sums values based on a condition. The condition can be applied to […]
Split expenses calculator
This article demonstrates two ways to calculate expenses evenly split across multiple people. The first one is a formula solution, […]
This article demonstrates two ways to calculate expenses evenly split across multiple people. The first one is a formula solution, […]
Working with Relational Tables in Excel
Excel 2010 has a PowerPivot feature and DAX formulas that let you work with multiple tables of data. You can […]
Excel 2010 has a PowerPivot feature and DAX formulas that let you work with multiple tables of data. You can […]
Working with running totals
Andrew asks: LOVE this example, my issue/need is, I need to add the results. So instead of States and Names, […]
Andrew asks: LOVE this example, my issue/need is, I need to add the results. So instead of States and Names, […]
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