=SUMPRODUCT(--($B$2:$B$200=--"10:00:00"),--($B$2:$B$200<--"10:15:00"),--($C$2:$C$200=1),$D$2:$D$200)

where B2:b200 is the times, C2:C200 is the categories, D2:D200 is the
amounts.

You can put the test values in cells and check against these, better in a
table.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Linda" wrote in message
...
We have to track our day in 15 minutes increments, some which are
billiable
or non-billable. I have set up the fomula that calculates the 15 minute
increments for each billable / non-billable. There are 4 billable and 4
non-billable categories, numbered 1 through 8 and these numbers are placed
in
1 column which corrresponds with each time. What I can't figure out is
how
to "pull" the data from the cells in each of the categories to one cell
representing each categorie. Each day will be different with different
times
for each category, so nothing remains static. Suggestions would be
greatly
appreciated.