Function: COUNT

Function: COUNT

COUNT is a statistics function that counts the numeric values within the specified range. A common use case for this function is counting the cells that have numeric values. In this guide, we’re going to show you how to use the COUNT function and also go over some...
Function: MINIFS

Function: MINIFS

The MINIFS is a statistics function that returns the minimum value of only the cells that meet certain criteria. In this guide, we’re going to show you how to use the Excel MINIFS function and also go over some tips and error handling methods.Supported Excel...
Function: MAXIFS

Function: MAXIFS

The MAXIFS Excel function is a statistics formula that returns the maximum value of only the cells that meet certain criteria. In this guide, we’re going to show you how to use the MAXIFS function and also go over some tips and error handling methods.Supported Excel...
Function: COUNTA

Function: COUNTA

The Excel COUNTA function is a statistics formula that returns the number of cells in a range containing numbers, text, logical values, error values, and empty text (“”). In this guide, we’re going to show you how to use the Excel COUNTA function and also...
Function: INDIRECT

Function: INDIRECT

The Excel INDIRECT function is a Lookup & Reference formula that returns the reference specified by a text string. It is useful for when you want to convert text strings into valid references. In this guide, we’re going to show you how to use the Excel INDIRECT...
Single operator

Single operator

With the dynamic arrays concept, formulas that return an array can spill the results to the neighboring cells automatically. However, this behavior conflicts with legacy implicit intersection formulas that use ranges (arrays). For the sake of backward compatibility,...
Spill Range Operator

Spill Range Operator

With the introduction of the dynamic arrays and spill concepts, Microsoft has also released a spill range operator (#). This operator is designed to reference spill ranges dynamically.For example, the cell D3 has =UNIQUE(B3:B16) formula which spills the return values...
Single operator

SINGLE Function

The Excel SINGLE function is a Lookup & Reference formula that returns a value using implicit intersection. In this guide, we’re going to show you how to use the Excel SINGLE function and also go over some tips and error handling methods. The Dynamic Array...
RANDARRAY Function

RANDARRAY Function

The RANDARRAY function is a Math & Trigonometry formula that creates an array of randomly generated numbers. In this guide, we’re going to show you how to use the RANDARRAY function and also go over some tips and error handling methods. The Dynamic Array functions...