Countblank same value in many ranges

  • Hi,
    Please help with this
    I have multiple ranges with identical horizontal and vertical headers, around 30 ranges and each range called One, Two, Three, etc
    Supposedly the horizontal header has A, B, and C
    And the vertical header has X, Y, and Z

    How could I countblank values under A horizontal header for X vertical header (repeated 30 times to confirm) with one formula?

  • Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

  • Do you want a formula or VBA? You have posted in the VBA section.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!