In this tutorial we are going to use the SUBTOTAL function to count the number of blank cells in a data range when using filters in Excel.
To download the file and follow along, go to the link here:
app.box.com/s/rglhqglg4kqir2m...
To learn more about the SUBTOTAL function, go to this tutorial:
• How To Use The SUBTOTA...
Do you need help with a formula or an Excel project?
You can send me an e-mail to mrempel@excel-bytes.com
Including a sample file is always helpful!
You can donate to my channel through any of the following:
PayPal:
paypal.me/ExcelBytes?locale.x...
Zelle or Venmo:
Send to mrempel@excel-bytes.com