+ Reply to Thread
Results 1 to 2 of 2

Count number of times a specific number is displayed in a cell ran

  1. #1
    subs
    Guest

    Count number of times a specific number is displayed in a cell ran

    How can I count the number of cells which contain a specific number? For
    example,
    a b c d e
    1 23 11 45 32 61
    2 5 86 143 21 97
    3 14 56 64 13 9
    4 63 51 111 32 76

    Cells A1:E4 = 8, the number "1" is displayed in 8 cells throughout the
    specified cell range.

  2. #2
    N Harkawat
    Guest

    Re: Count number of times a specific number is displayed in a cell ran

    =SUMPRODUCT(--ISNUMBER(FIND(1,A1:E4)))

    "subs" <subs@discussions.microsoft.com> wrote in message
    news:8C162120-2898-4B3E-9F34-86A9A06F6730@microsoft.com...
    > How can I count the number of cells which contain a specific number? For
    > example,
    > a b c d e
    > 1 23 11 45 32 61
    > 2 5 86 143 21 97
    > 3 14 56 64 13 9
    > 4 63 51 111 32 76
    >
    > Cells A1:E4 = 8, the number "1" is displayed in 8 cells throughout the
    > specified cell range.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1