Consulting

Results 1 to 3 of 3

Thread: Solved: Counting by Vehicle number

  1. #1

    Solved: Counting by Vehicle number

    I have an excel sheet layed out to resemble a Parking area, and want to enter in each cell resembling a given parking space the vehicle number. I want to be able to count a running total of vehicles with a given range of numbers ( Vehicles Numbered XXXX - XXXX ) How many in each given range. We have a total of 6 Ranges of numbers. A given range/array may be C3:H75
    Scooter172

  2. #2
    VBAX Tutor
    Joined
    Jan 2008
    Posts
    262
    Location
    How about using a COUNTIFS function with your condition being to count if the number if is your specified range of parking bay numbers?

  3. #3
    VBAX Expert shrivallabha's Avatar
    Joined
    Jan 2010
    Location
    Mumbai
    Posts
    750
    Location
    If blank represents empty slot and non-blank represents filled then following shall work as you need:
    =COUNTA(C3:H75 )
    Regards,
    --------------------------------------------------------------------------------------------------------
    Shrivallabha
    --------------------------------------------------------------------------------------------------------
    Using Excel 2016 in Home / 2010 in Office
    --------------------------------------------------------------------------------------------------------

Posting Permissions

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