Aggregate Function in Excel | Tips & Tricks | Returns sum optionally ignoring error Values |
AGGREGATE function
Returns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.
Reference form
AGGREGATE(function_num, options, ref1, [ref2], …)
Array form
AGGREGATE(function_num, options, array, [k])
-----------------------------------------------------------------------------------------------------------------------
Aggregate Function in Excel | Tips & Tricks | Returns a calculation optionally ignoring error Values
**********************************************************************
Please Subscribe My Channel:
/ excelplanet
**********************************************************************
Playlists Link
9999 Excel Tips and Tricks
• 9999 Excel Tips and Tricks
0001 Introduction to Excel
• 0001 Introduction to Excel
0002 Entering and Editing Data in Excel
• 0002 Entering and Editing Data in Excel
0003 Worksheet View Control
• 0003 Excel Worksheet Operations & Features
0004 Working with Cells and Ranges
• 0004 Cells and Ranges in Excel
0005 Excel Tables and its Features
• 0005 Excel Tables and its Features
0006 Worksheet Formatting
• 0006 Worksheet Formatting
0007 Understanding Excel Files
• 0007 Understanding Excel Files
0008 Using and Creating Templates
• 0008 Using and Creating Templates
0009 Printing Your Work
• 0009 Printing Your Work
***************************************************************************************
#Shorts #AggregateFunction #TipsAndTricks
#Excel #ExcelPlanet #maniya44
#MSExcel #Maniya44 #Learn
#Education #Training #Tutorial
#LearnExcel #Excel2013 #ExcelFunctions
#ExcelTutorial #Excel2016 #ExcelFormulas
#ELearning #Excel2019 #ExcelPivot
#Software #MicrosoftExcel #HowTo
#Application #How #subscribe
#PrintSettings #Print #PageSetup
#WaterMark #Header #Footer
#HeaderAndFooter #Codes #Options
#PagesetupSettings #PreventCellsFromPrinting
#Cells #PreventObjectsFromPrinting
#Objects #CreatingCustomViews
#CustomViews #CreatingPdfFiles #Create
#CustomView #PdfFiles #CreatePDF
***************************************************************************************