Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    May 2012
    Posts
    2
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Can COUNTIF do consecutive numbers by dragging the lower right corner?

    I have a database of about 1000 students that attend about 8 classes a month and I am trying to create a program that counts how many times each student visits. If I use the COUNTIF function, it gives me what I want, but I have to type in very similar cells 1000 times every month. Please take a look at my example spreadsheet and I would appreciate any pointers on how I can do this.
    Thank you,
    Anthony Blackman
    English BuffetCOUNTIF example problem.xls

  2. #2
    Star Lounger
    Join Date
    Aug 2011
    Posts
    59
    Thanks
    23
    Thanked 2 Times in 2 Posts
    Unless I am missng something, in G3 enter =COUNTIF($C$3:$C$20,F3) and drag down.

    In J3 enter =COUNTIF($C$3:$C$20,I3) and drag down

  3. The Following User Says Thank You to jrb For This Useful Post:

    English Buffet (2012-05-04)

  4. #3
    Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,494
    Thanks
    28
    Thanked 171 Times in 167 Posts
    Hi

    Welcome to the Lounge!
    Your problems would disappear if you use this formula in cell [G3]
    =COUNTIF($C:$C,F3)
    ..you can copy this formula down (quickest way is put the cellpointer in cell [G3], press ctrl-C, and then carefully use mouse to point to the bottom-right-corner of this selected cell where you will see the cursor change from the 'fat white cross' to a 'thin black cross' and then just double-click, this will copy the formula all the way down until it reaches an empty cell).

    see attached file

    zeddy
    Attached Files Attached Files

  5. The Following User Says Thank You to zeddy For This Useful Post:

    English Buffet (2012-05-04)

  6. #4
    New Lounger
    Join Date
    May 2012
    Posts
    2
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Problem solved. That helped a bunch

  7. #5
    Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,494
    Thanks
    28
    Thanked 171 Times in 167 Posts
    May the fourth be with you.

    zeddy

  8. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,243
    Thanks
    202
    Thanked 796 Times in 729 Posts
    Quote Originally Posted by zeddy View Post
    May the fourth be with you.

    zeddy
    Zeddy,

    Go one better..."May the FIFTH be with you..." of course I don't know how that would translate into liters.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  9. #7
    Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,494
    Thanks
    28
    Thanked 171 Times in 167 Posts
    RG
    We no need no stinkin litres in UK
    We still use gills, quarts.
    You Americans are always takin the FIFTH
    Welcome back from your road trip.

    zeddy

  10. #8
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,243
    Thanks
    202
    Thanked 796 Times in 729 Posts
    Zeddy,

    Thanks but not back yet just in a campground with Wi-fi. We don't plan to be back till mid July.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  11. #9
    Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,494
    Thanks
    28
    Thanked 171 Times in 167 Posts
    Hi RG

    Just a short holiday then.

    zeddy

  12. #10
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,896
    Thanks
    0
    Thanked 86 Times in 82 Posts
    It would be quicker to use a pivot table I would think.
    Regards,
    Rory
    Microsoft MVP - Excel.

Posting Permissions

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