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. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Star Lounger
    Join Date
    Aug 2011
    Posts
    58
    Thanks
    21
    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

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

    English Buffet (2012-05-04)

  5. #3
    Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,474
    Thanks
    22
    Thanked 167 Times in 163 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

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

    English Buffet (2012-05-04)

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

  8. #5
    Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,474
    Thanks
    22
    Thanked 167 Times in 163 Posts
    May the fourth be with you.

    zeddy

  9. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    5,957
    Thanks
    193
    Thanked 730 Times in 666 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


  10. #7
    Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,474
    Thanks
    22
    Thanked 167 Times in 163 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

  11. #8
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    5,957
    Thanks
    193
    Thanked 730 Times in 666 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


  12. #9
    Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,474
    Thanks
    22
    Thanked 167 Times in 163 Posts
    Hi RG

    Just a short holiday then.

    zeddy

  13. #10
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,870
    Thanks
    0
    Thanked 79 Times in 75 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
  •