Como sumo datos correspondientes a fechas

[stephanieazul]

Tengo una columna "B" que va desde 07/12/2008 hasta 08/06/2008 y en la columna "E" datos específicos para esa fecha, como cuento cuantas llamadas hubieron en esa fecha especifica(necesito la formula en ingles porque mi excel esta en inglés) ya he tratado de todo!!!:

<table border="0" cellpadding="0" cellspacing="0" width="134"><col style="width: 48pt;" width="64"> <col style="width: 53pt;" width="70"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; width: 48pt;" width="64" height="20"> <table border="0" cellpadding="0" cellspacing="0" width="134"><col style="width: 48pt;" width="64"> <col style="width: 53pt;" width="70"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt; width: 48pt;" align="center" width="64" height="20">Date</td> <td class="xl68" style="border-left: medium none; width: 53pt;" align="center" width="70">ACD
Calls</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/12/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/12/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/12/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/13/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/13/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/13/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/13/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/14/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/14/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/14/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/14/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/14/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">14</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/14/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/12/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/12/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">11</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/12/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" align="center" height="20">7/12/2008</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">0</td> </tr> </tbody></table></td> <td class="xl68" style="width: 53pt;" width="70">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
</td> <td class="xl67">
</td> </tr> </tbody></table>

 

[Greg Truby]

=sumif(b2:b50,date(2008,7,14),e2:e50)

 

[galileogali]

Que tal Greg!!!

Frente a la pregunta yo me inclino más por Menu Datos >> Subtotales
por cada cambio en Date, resumir por SUMA en el Campo Calls

o Tal vez una Tabla Dinamica

o tu formula

si(b1=b2,"",sumif(b$2:b$50,date(Year(b2),month(b2),Day(b2)),e$2:e$50)

y despues aplicar AUTOFILTER pra ver solo las filas no VACIAS en la columna de sumas