AGGREGATE FUNCTION TO ERROR VALUES SUM|excal series magic tricks #excel#AGGREGATE

Hi, This is excal magic channel. In this channel we share different type of excal tips.In this video how to use aggregate function in excel #excel#aggregate#sum#error values sum#excel tips#data analyses

The AGGREGATE function in Excel is a formula that can perform calculations on columns of data, or vertical ranges, and return a single value as a summary result:

What it does

The AGGREGATE function can perform calculations like averages and sums, and ignore specific rows or errors.

How to use it

The syntax for the AGGREGATE function is =AGGREGATE(function_num, options, ref1, [ref2], …).

Parameters

function_num: A number (1-19) representing the function you want to use.

options: A number (0-7) that specifies which values or cells you wish to ignore during the calculation.

ref1, ref2, …: The range of cells or numbers you want the function to calculate. 

Next video link

[ad_2]

source