Boss of All Functions : Learn Use of Aggregate Function in Excel Bangla

Boss of All Functions : Learn Use of Aggregate Function in Excel Bangla


The Microsoft Excel AGGREGATE function allows you to apply functions such AVERAGE, SUM, COUNT, MAX or MIN and ignore errors or hidden rows.

The AGGREGATE function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the AGGREGATE function can be entered as part of a formula in a cell of a worksheet.

It was created by Microsoft to address the limitations of conditional formatting. Some conditional formatting can not be applied if there are errors in the range. The Excel AGGREGATE function allows you to ignore errors or hidden rows.

There are 2 syntaxes for the AGGREGATE function:
REFERENCE Syntax
The REFERENCE syntax for the Microsoft Excel AGGREGATE function is:
AGGREGATE( function, options, reference1, [reference2], ... )

ARRAY Syntax
The ARRAY syntax for the Microsoft Excel AGGREGATE function is:
AGGREGATE( function, options, array, [optional_argument] )

I think you have enjoyed this video.

If this tutorial really helps you, please like, comment, subscribe and share with your close friends. This is #ms_excel #bangla #tutorial #mamun_academy


............................................................................
..............Subscribe to Get More Videos...........
https://www.youtube.com/c/MaMuNAcadem...
............................................................................

..................................................................................................
Most Favorite Videos

আমার ভিডিও /টিউটোরিয়াল কোথা থেকে শুরু করবেন ?
   • How  My Tutorial Arranged_About MamuN...  


MS Excel Bangla Tutorial Playlist :

Excel Super Secret Tips & Tricks: https://goo.gl/5qSphJ
Mastery of If Function Bangla: https://goo.gl/jY76m4
MS Excel Essential Course : https://goo.gl/7EX1hk
MS Excel Intermediate Course: https://goo.gl/iatnNz
MS Excel Advanced Course: https://goo.gl/WFrvzU
MS Excel Formulas & Functions: https://goo.gl/7Da7oZ
MS Excel Pivot Table Magic: https://goo.gl/NGp13W
MS Word Essential Course: https://goo.gl/SVXefG
Magic of Conditional Formatting Bangla : https://goo.gl/j4N3sH
Mastery of VLOOKUP Function : https://goo.gl/1YAZ5y
XLOOKUP : A New Awesome Excel Function : http://bit.ly/2rbQSj0
Result Sheet Making Bangla : https://goo.gl/VnuZk6
Salary Sheet Making Hidden Tricks : https://goo.gl/KXsfyh
Master of Pivot Table : https://goo.gl/PaGUzj
MS Word Magic and Tips and Tricks : https://goo.gl/6b25kB
MS PowerPoint 2019 Bangla: https://goo.gl/eoeeMm
MS PowerPoint Tutorial Bangla : Be Pro : http://bit.ly/2PYIcqR
..................................................................................................


.................Social Media.................


Twitter :   / cumamun  
Google+ : https://plus.google.com/mamunacademy
LinkedIn :   / abdulla-al-mamun-172629b4  
Instagram:   / al-mamun36  

..............................................

........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & http://www.bensound.com

Intro/Outro/Banner Creator:
Official™ ► http://bit.ly/OffTMDesigns
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................


Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks. .
.................................................................................................

.................Social Media.................
Facebook Page :   / mamunacademy4u  
Facebook Group :   / mamunacademy  
Google+ : https://plus.google.com/mamunacademy
LinkedIn :   / abdulla-al-mamun-172629b4  
..............................................

........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & http://www.bensound.com

Intro/Outro/Banner Creator:
Official™ ► http://bit.ly/OffTMDesigns
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................

Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks.