How to include numbers with hyphens in Subtotal function

Jack Allen 0 Reputation points
2024-06-11T18:33:18.1633333+00:00

I am currently using a =SUBTOTAL formula to count a column of date but am having some issues. For example, I have 30 cells in this column that all include various numbers, but they also include numbers with hyphens— ex. 20-22, 106-107 etc.

when i run the =SUBTOTAL(2, E3:E32) it does not include the cells that contain numbers with hyphens, so my total number is off. I have tried changing the format of the numbers to General and am still having the same issue.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,685 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 23,896 Reputation points Microsoft Vendor
    2024-06-12T02:18:07.56+00:00

    Hi,

    You can try to use COUNTA function to help you count cells not empty:

    User's image

    If my understanding is incorrect, please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments