Function: SUMPRODUCT

Function: SUMPRODUCT

by | Mar 28, 2019

The SUMPRODUCT Excel formula is a Math & Trig function that multiplies the values in arrays, and returns the sum of products. Although this sounds like something you could do using a combination of the SUM and the PRODUCT formulas, there is more to it! Thanks to...
Function: COLUMNS

Function: COLUMNS

by | Mar 19, 2019

The Excel COLUMNS function returns the number of columns in a selection. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax SUMIF(range, criteria,...
Function: ROWS

Function: ROWS

by | Mar 19, 2019

The Excel ROWS function is a Lookup & Reference formula that returns the number of rows in an array, an array formula, or a range of cells. In this guide, we’re going to show you how to use the Excel ROWS function and also go over some tips and error handling...
Function: RANDBETWEEN

Function: RANDBETWEEN

by | Mar 15, 2019

The RANDBETWEEN function returns a random integer number between the numbers specified. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods.Supported versionsAll Excel versionsSyntax RANDBETWEEN(bottom,...
Function: RAND

Function: RAND

by | Mar 15, 2019

The RAND function returns an evenly distributed random numbers greater than or equal to 0 and less than 1. In this guide, we’re going to show you how to use the RAND function and also go over some tips and error handling methods.Supported versionsAll Excel...
Function: SUBTOTAL

Function: SUBTOTAL

by | Mar 14, 2019

The Excel SUBTOTAL function returns the subtotal of the specified values. The function works like a combination of aggregation formulas of Excel, and allows you to determine the function with the use of a separate parameter. What separates the SUBTOTAL function from...
Function: COUNT

Function: COUNT

by | Mar 11, 2019

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...
Tips for Excel Tables

Tips for Excel Tables

by | Mar 8, 2019

Excel Table is a tool for managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which includes filtering, formatting, sizing, and auto populating formulas dynamically. In this guide, we’re going to go over some...
Function: MINIFS

Function: MINIFS

by | Mar 7, 2019

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