counting problem - Page 2
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: counting problem

  1. #11
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,334
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

     


    With criteria in D1 and D2

    =COUNTIF(B1:B26,">"&D1)-COUNTIF(B1:B26,">"&D2)

  2. #12
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-15 20:16, Dave Patton wrote:


    With criteria in D1 and D2

    =COUNTIF(B1:B26,">"&D1)-COUNTIF(B1:B26,">"&D2)
    Hi Dave: Looks Good!
    And to go a step further

    =COUNTIF(B1:B26,E1)-COUNTIF(B1:B26,E2)

    if E1 contained the criterion ... <11
    and E2 contained ... <=1

    _________________
    Yogi Anand
    Edit: Deleted reference to inactive web site from signature line

    [ This Message was edited by: Yogi Anand on 2003-01-19 18:24 ]

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