COUNT formula - Page 2
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: COUNT formula

  1. #11
    Board Regular
    Join Date
    Apr 2002
    Location
    California
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    REPLY to Dave Patton
    Re: "Several people suggested solutions; what happened when you adjusted to relevant ranges and tried the formula?"

    I used the formula: =SUBTOTAL(3,D3:D409), and the it produced correct result relative to each item filtered within the range.

    Dave (and all who responded), thanks for guidance. My learning curve has spiked since I discovered this site.

  2. #12
    Board Regular
    Join Date
    Apr 2002
    Location
    California
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To Dave
    RE: Several people suggested solutions; what happened when you adjusted to relevant ranges and tried the formula?

    I used this formula: =SUBTOTAL(3,range).
    It gave me the total number in the range.
    I then filtered the column for each items, and the cell with the formula reflected appropriate count for each filtered item.

    Thanks to all who've responded. My learning curve is spiking with every MB contact.

  3. #13
    Board Regular
    Join Date
    Apr 2002
    Location
    California
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    ________________________________
    FROM KATH
    TO DAVE

    Dave, I tried twice to reply, but neither was posted (problem?) Anyway,
    The formula used: =SUBTOTAL(3,D3:D409)
    It worked in the dbase to yield the total count of ALL items. Then, in the filters, it yielded the relative count for each item filtered.
    SUCCESS. Thanks for the assist & guidance, to one and all! My learning curve is spiking with discovery of this site.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com