Hi,

What I am trying to do is a kind of distribution. What I want to come to is something like this:

Book#------How long to read?------
1234 1-2 hours? 2-3 hours? 3-4 hours? more than 4 hours.

1234 7 11 6 1


The data is on one sheet and I did a quick pivot on sheet2 to get all unique book numbers. Now in each row on sheet 2 (in the columns next to the unique book number) I would like the count of how many times a value (hours) appears in the hours column of the specified book. The first sheet containing the data looks something like this:

Name Book Hours
Jenny 1234 2.25
Bart 1234 2
Martha 1234 6
Bill 7958 11
Bob 1234 1.5

The trick is to have the function look for a match of the sheet 2 book number to sheet 1 and count how many times a value appears (on sheet 1) that falls between a range. Since I have thousands of books, I need the funtion to search instead of me.

Seems like I need a vlookup combined with a count function or perhaps I am just confused.

Thanks,

swjtx