Calculating the number of values between specified ranges

G

Guest

Column H is a list of numbers which represent how late deliveries are in
minutes.

I need to be able to create a table on a new sheet which states how many of
the values in column H are between 0-10, 11-20, 21-30 etc... I am unable to
do this presently. Does anyone know a formula, lookup or pivot table that
will count the number of values in column H that are within the specified
ranges?

Any help would be greatly appreciated. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had 2
SUMPRODUCT HELP 2
COUNT BETWEEN A RANGE AND 16
Using text values in Pivot Tables 5
Calculating Days Late 1
Pivot Data Ranges 1
Count number of times two columns have desired values 2
Calculating the number of unique values with a range 3

Top