PDA

View Full Version : Solved: Counting by Vehicle number



Scooter172
03-27-2013, 08:16 PM
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
:whip

sassora
03-28-2013, 01:24 AM
How about using a COUNTIFS function with your condition being to count if the number if is your specified range of parking bay numbers?

shrivallabha
03-28-2013, 11:54 PM
If blank represents empty slot and non-blank represents filled then following shall work as you need:
=COUNTA(C3:H75 )