Hello. I have a worksheet with several columns of information. What I need
help with are only two of the columns. One column lists the number of
vacation hours available for each employee of our company. The other column
is their rate of pay. Both columns have been formulated to multiply one by
the other and subtotaled.

Now, I need to create 3 more separate columns that will give a break down of
the various vacation hours such as.....0-80 hours in one column, 81-120 hours
in another and 121 hours and above in another column and grand total each
column. Hope this makes sense. I hope someone can help. Thanks