Calculation Formula to Sum when Using Filter

Posted on 2012-09-20
Last Modified: 2012-09-20
EE Professionals;

Can someone give me a formula or function that "counts" the records (Blanks or Non-Blanks) in a FILTERED Column?  In other words as I filter a table (A1:D100) and it changes the number of records (A Subset), how do I count the new list?

Thank you,

Question by:Bright01
    LVL 24

    Accepted Solution

    Use subtotal
    Subtotal 102 will count the visible numbers in the range:
    Typing =Subtotal( should give you a list of available total types

    Author Closing Comment

    Thank you!  It was simpler then we had orginally thought.  Very helpful.

    Again, much thanks!


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    This is about my first experience with programming Arduino.
    Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now