What is the Excel AVERAGEA Function? The excel AVERAGEA function calculates like the excel AVERAGE function. The AVERAGE function and the AVERAGEA function return different results when there are logical values (TRUE / FALSE), empty text or text representations of numbers. The AVERAGE function ignores these …
What is the Excel SUBTOTAL Function? The Excel SUBTOTAL function returns a value from 11 available functions such as SUM, COUNT, AVERAGE, MIN, MAX, etc. (see table below for complete function list) with an option to include or exclude the hidden rows. SUBTOTAL Syntax SUBTOTAL(function_num,ref1,,...) function_num, …
What is the Excel AGGREGATE Function? The Excel AGGREGATE function returns an aggregate calculation from 19 available function with eight available options. AGGREGATE Syntax AGGREGATE(function_num, options, ref1, ref2) function_num, required, a function to use (1-19). options, required, which values to ignore (0-7) ref1, required, the first …
