'Sum' category
How to do tiered calculations in one formula
The image above demonstrates a formula that calculates tiered values based on a tier table and returns a total. This […]
The image above demonstrates a formula that calculates tiered values based on a tier table and returns a total. This […]
How to sum a cell range
I will in this article demonstrate different ways to sum values, the first method is so easy and fast it's […]
I will in this article demonstrate different ways to sum values, the first method is so easy and fast it's […]
Excel formula not working
This article explains why your formula is not working properly, there are usually four different things that can go wrong. […]
This article explains why your formula is not working properly, there are usually four different things that can go wrong. […]
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 […]
This article demonstrates a formula that calculates a running total. A running total is a sum that adds new numbers […]
Find empty cells and sum cells above
This article demonstrates how to find empty cells and populate them automatically with a formula that adds numbers above and […]
This article demonstrates how to find empty cells and populate them automatically with a formula that adds numbers above and […]
Sum numerical ranges between two numbers
This article explains how to build an array formula that sums numerical ranges. Example, I want to know how to […]
This article explains how to build an array formula that sums numerical ranges. Example, I want to know how to […]
Running totals based on criteria
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, […]
Sum based on OR – AND logic
Question: It's easy to sum a list by multiple criteria, you just use array formula a la: =SUM((column_plane=TRUE)*(column_countries="USA")*(column_producer="Boeing")*(column_to_sum)) But all […]
Question: It's easy to sum a list by multiple criteria, you just use array formula a la: =SUM((column_plane=TRUE)*(column_countries="USA")*(column_producer="Boeing")*(column_to_sum)) But all […]
Sum unique numbers
Table of Contents Sum unique numbers Get Excel *.xlsx file Sum unique distinct numbers Get Excel *.xlsx file Sum number […]
Table of Contents Sum unique numbers Get Excel *.xlsx file Sum unique distinct numbers Get Excel *.xlsx file Sum number […]
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