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