How to Use The Count Function While Ignoring Error Values.
What's going on YouTube? In this tutorial, I show you how you can use the count function while ignoring error values such as DIV/O and NA by using the aggregate function. The first argument is a number that corresponds to what you want to calculate, the count in this situation. The second argument is what you want to ignore, being the error values in this situation, the third argument is the range of cells that you want to perform the calculation on, and the forth argument is optional which is indicated by how it is in brackets so it is not used in this example as the function will work without it. Thank you for watching this video, and if you liked it, please like, subscribe, and comment. Thank you again for watching, and I hope that you have a great day! Also, please check out the links below to help support the channel :)
Webull -
https://act.webull.com/po/fzBiRJtlXkp...
Robinhood -
https://join.robinhood.com/brandos302...
First Trade -
https://share.firstrade.com/BrandonWU...
Yotta Savings -
https://withyotta.page.link/DWYq7wksG...
Learn more about excel formulas and functions
https://amzn.to/3qJAZtM
Get Microsoft Office 365
https://amzn.to/3a6cBeX