bleggee
asked on
Using EXCEL to count the number of Rows
Hi all - How do I use Excel to give me the number of rows containing a certain item, for all rows?
See 2 tiny examples attached ... that should explain everything! I want excel to tell me how many Cars, how many Boats, and how many Trucks I have. The file is already sorted on that field, and formatting and location of the result is not important ... I just need the numbers. (The actual spreadsheets have 20,000+ records in them)
What-I-want.xlsx
What-I-have.xlsx
See 2 tiny examples attached ... that should explain everything! I want excel to tell me how many Cars, how many Boats, and how many Trucks I have. The file is already sorted on that field, and formatting and location of the result is not important ... I just need the numbers. (The actual spreadsheets have 20,000+ records in them)
What-I-want.xlsx
What-I-have.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER