Index or Something Else?

[Amigo602]

I need some help pulling a summary row by looking up the queue name. Here is what I am looking at.

<table border="0" cellpadding="0" cellspacing="0" width="565"><col style="width: 192pt;" width="256"> <col style="width: 98pt;" width="131"> <col style="width: 134pt;" width="178"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 192pt;" width="256" height="20">Call Type Name</td> <td class="xl65" style="border-left: medium none; width: 98pt;" width="131">Date</td> <td class="xl65" style="border-left: medium none; width: 134pt;" width="178">Calls Handled</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none; width: 192pt;" width="256" height="20">Queue1</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 98pt;" width="131">8/8/2011</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 134pt;" align="right" width="178">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt; border-top: medium none; width: 192pt;" width="256" height="20">Queue1</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 98pt;" width="131">
</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 134pt;" align="right" width="178">1</td> </tr> <tr style="height: 15pt;" height="20"> <td rowspan="2" class="xl68" style="border-bottom: 0.5pt solid black; height: 30pt; border-top: medium none; width: 192pt;" width="256" height="40">Queue2</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 98pt;" width="131">8/8/2011</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 134pt;" align="right" width="178">763</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none; border-left: medium none; width: 98pt;" width="131" height="20">8/9/2011</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 134pt;" align="right" width="178">844</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt; border-top: medium none; width: 192pt;" width="256" height="20">Queue2</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 98pt;" width="131">
</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 134pt;" align="right" width="178">1607</td> </tr> <tr style="height: 15pt;" height="20"> <td rowspan="2" class="xl68" style="border-bottom: 0.5pt solid black; height: 30pt; border-top: medium none; width: 192pt;" width="256" height="40">Queue3</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 98pt;" width="131">8/8/2011</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 134pt;" align="right" width="178">3</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none; border-left: medium none; width: 98pt;" width="131" height="20">8/9/2011</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 134pt;" align="right" width="178">2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt; border-top: medium none; width: 192pt;" width="256" height="20">Queue3</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 98pt;" width="131">
</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 134pt;" align="right" width="178">5</td> </tr> </tbody></table>
So A1 is "Call Type Name", B1 is "Date", and C1 is "Calls Handled".

I need a formula that finds "Queue1" and goes down to the next "Queue1" and then over to "handled calls" which is sum of both.

For example, I need to return the summary for "Queue2" Handled Calls(1607). Every formula I write gets stuck at the first "Queue2".

I am pulling this info to a sheet named "Shift" and pasted info up above is on a sheet named "Cisco Shift".

Your help is greatly appreciated!

 

[Thomas_Lafferty]

Is it possible to clean up your original data a bit? If summary info is removed, you can then just use a pivot table. If you can post a sample book, I'll take a look at it for you.