## 'SUMIFS function' category

How to use the SUMIFS function

The SUMIFS function calculates a total based on multiple criteria, it has been available in Excel since version 2010. I […]

The SUMIFS function calculates a total based on multiple criteria, it has been available in Excel since version 2010. I […]

Sum numbers between two dates

The formula in cell C15 uses two dates two to filter and then sum values in column C, the SUMIFS […]

The formula in cell C15 uses two dates two to filter and then sum values in column C, the SUMIFS […]

Auto populate a worksheet

Rodney Schmidt asks: I am a convenience store owner that is looking to make a spreadsheet formula. I want this […]

Rodney Schmidt asks: I am a convenience store owner that is looking to make a spreadsheet formula. I want this […]

Sum cells based on criteria

Katie asks: I have 57 sheets many of which are linked together by formulas, I need to get numbers from […]

Katie asks: I have 57 sheets many of which are linked together by formulas, I need to get numbers from […]

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, […]

Extract a unique distinct list and sum amounts based on a condition

Anura asks: Is it possible to extend this by matching items that meet a criteria? I have a list of […]

Anura asks: Is it possible to extend this by matching items that meet a criteria? I have a list of […]

Sum values between two dates and based on a condition

In this post, I will provide a formula to sum values in column (Qty) where a column (Date) meets two […]

In this post, I will provide a formula to sum values in column (Qty) where a column (Date) meets two […]

## 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