How to Use The Count Function While Ignoring Error Values.

Published: 01 January 1970
on channel: Brandon's Excel Tutorials

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

On this page of the site you can watch the video online How to Use The Count Function While Ignoring Error Values. with a duration of hours minute second in good quality, which was uploaded by the user Brandon's Excel Tutorials 01 January 1970, share the link with friends and acquaintances, this video has already been watched 47 times on youtube and it was liked by 2 viewers. Enjoy your viewing!

474