Conditional Min

rweissmann

New Member
Joined
Sep 26, 2011
Messages
1
En unas hojas de excel tengo unos 500000 datos del siguiente tipo
A Sucursal de Radicacion Ej 2
B Sucursal de Pago Ej 2
C Nro de Beneficio Ej 010235905904
D Total Bruto de Haberes Ej 1.272,78
E Descuentos Anses Ej 69,80
F Importe Mora Afip Ej 0,00
G Importe Retroactivo Mora Afip Ej 0,00
H Total Descuentos Anses 69,80
I Importe Liquido Beneficiario 1202,98
J Importe Anses 1202,98
K Acreditacion en Cuenta (Sí/No) No
Tengo Cajones de Remuneraciones Brutas y Netas
<=1227
>1227 y <=2000
>2000 y <=3000
>3000 y <=5000
>5000 y <=89440
>8944





Quiero hallar maximo y minimo global de remuneraciones por categoria salarial

=MIN(SUMAPRODUCTO(MIN((--('2A19'!$D$3:$D$65126=0)*(('2A19'!$D$3:$D$65126<=1227)*1)*SUMA('2A19'!$D$3:$D$65126)+('2A19'!$D$3:$D$65126))));SUMAPRODUCTO(MIN((--('20A100'!$D$4:$D$63606=0)*(('20A100'!$D$4:$D$63606<=1227)*1)*(SUMA('20A100'!$D$4:$D$63606)*1)+('20A100'!$D$4:$D$63606))));SUMAPRODUCTO(MIN((--('101A136'!$D$4:$D$65080=0)*(('101A136'!$D$4:$D$65080<=1227)*1)*(SUMA('101A136'!$D$4:$D$65080)*1)+('101A136'!$D$4:$D$65080))));SUMAPRODUCTO(MIN((--('137A209'!$D$4:$D$60551=0)*(('137A209'!$D$4:$D$60551<=1227)*1)*(SUMA('137A209'!$D$4:$D$60551)*1)+('137A209'!$D$4:$D$60551))));SUMAPRODUCTO(MIN((--('210A215'!$D$4:$D$9172=0)*(('210A215'!$D$4:$D$9172<=1227)*1)*(SUMA('210A215'!$D$4:$D$9172)*1)+('210A215'!$D$4:$D$9172)))))
Aqui da valores correctos, pero aqui uso Min con condiciones Importe <= 1227

El problema se complica con MIN y condiciones multiples del tipo >XXX Y <=ZZZ ya que trae cero en lugar de Nros >1228, 2001, 3001, 5001, 8945...
=MIN(MIN(SI(Y('2A19'!$D$3:$D$65126>1227;'2A19'!$D$3:$D$65126<=2000);'2A19'!$D$3:$D$65126;1228));MIN(SI(Y('20A100'!$D$4:$D$63606>1227;'20A100'!$D$4:$D$63606<=2000);'20A100'!$D$4:$D$63606;1228));MIN(SI(Y('101A136'!$D$4:$D$65080>1227;'101A136'!$D$4:$D$65080<=2000);'101A136'!$D$4:$D$65080;1228));MIN(SI(Y('137A209'!$D$4:$D$60551>1227;'137A209'!$D$4:$D$60551<=2000);'137A209'!$D$4:$D$60551;1228));MIN(SI(Y('210A215'!$D$4:$D$9172>1227;'210A215'!$D$4:$D$9172<=2000);'210A215'!$D$4:$D$9172;1228)))

=MIN(MIN(SI(Y('2A19'!$D$3:$D$65126>2000;'2A19'!$D$3:$D$65126<=3000);'2A19'!$D$3:$D$65126;2001));MIN(SI(Y('20A100'!$D$4:$D$63606>2000;'20A100'!$D$4:$D$63606<=3000);'20A100'!$D$4:$D$63606;2001));MIN(SI(Y('101A136'!$D$4:$D$65080>2000;'101A136'!$D$4:$D$65080<=3000);'101A136'!$D$4:$D$65080;2001));MIN(SI(Y('137A209'!$D$4:$D$60551>2000;'137A209'!$D$4:$D$60551<=3000);'137A209'!$D$4:$D$60551;2001));MIN(SI(Y('210A215'!$D$4:$D$9172>2000;'210A215'!$D$4:$D$9172<=3000);'210A215'!$D$4:$D$9172;2001)))

=MIN(MIN(SI(Y('2A19'!$D$3:$D$65126>3000;'2A19'!$D$3:$D$65126<=5000);'2A19'!$D$3:$D$65126;3001));MIN(SI(Y('20A100'!$D$4:$D$63606>3000;'20A100'!$D$4:$D$63606<=5000);'20A100'!$D$4:$D$63606;3001));MIN(SI(Y('101A136'!$D$4:$D$65080>3000;'101A136'!$D$4:$D$65080<=5000);'101A136'!$D$4:$D$65080;3001));MIN(SI(Y('137A209'!$D$4:$D$60551>3000;'137A209'!$D$4:$D$60551<=5000);'137A209'!$D$4:$D$60551;3001));MIN(SI(Y('210A215'!$D$4:$D$9172>3000;'210A215'!$D$4:$D$9172<=5000);'210A215'!$D$4:$D$9172;3001)))

=MIN(MIN(SI(Y('2A19'!$D$3:$D$65126>5000;'2A19'!$D$3:$D$65126<=8944);'2A19'!$D$3:$D$65126;5001));MIN(SI(Y('20A100'!$D$4:$D$63606>5000;'20A100'!$D$4:$D$63606<=8944);'20A100'!$D$4:$D$63606;5001));MIN(SI(Y('101A136'!$D$4:$D$65080>5000;'101A136'!$D$4:$D$65080<=8944);'101A136'!$D$4:$D$65080;5001));MIN(SI(Y('137A209'!$D$4:$D$60551>5000;'137A209'!$D$4:$D$60551<=8944);'137A209'!$D$4:$D$60551;5001));MIN(SI(Y('210A215'!$D$4:$D$9172>5000;'210A215'!$D$4:$D$9172<=8944);'210A215'!$D$4:$D$9172;5001)))

=MIN(MIN(SI(Y('2A19'!$D$3:$D$65126>0;'2A19'!$D$3:$D$65126>8944);'2A19'!$D$3:$D$65126;8945));MIN(SI(Y('20A100'!$D$4:$D$63606>0;'20A100'!$D$4:$D$63606>8944);'20A100'!$D$4:$D$63606;8945));MIN(SI(Y('101A136'!$D$4:$D$65080>0;'101A136'!$D$4:$D$65080>8944);'101A136'!$D$4:$D$65080;8945));MIN(SI(Y('137A209'!$D$4:$D$60551>0;'137A209'!$D$4:$D$60551>8944);'137A209'!$D$4:$D$60551;8945));MIN(SI(Y('210A215'!$D$4:$D$9172>0;'210A215'!$D$4:$D$9172>8944);'210A215'!$D$4:$D$9172;8945)))

Traen un minimo de cero en lugar de >1227, >2000, >3000, >5000, >8944


=BDMIN('2A19'!$A$3:$K$65126;"TotalHaberes";$AC$31:$AD$32)
da #!VALOR aun entrando en formato matricial con Ctrl Shift Enter
<table style="WIDTH: 309pt; BORDER-COLLAPSE: collapse" border="0" cellpadding="0" cellspacing="0" width="412"> <colgroup></colgroup> <col style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3364" width="92"> <col style="WIDTH: 60pt" span="4" width="80"> <tbody> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 69pt; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15" width="92">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" width="80">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" width="80">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" width="80">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 60pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" width="80">
</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">=MIN()</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">=MIN()</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">1.228,00</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">1.228,00</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">2.001,00</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">2.001,00</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" align="center">#¡VALOR!</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">2.001,00</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">2.001,00</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">2.001,00</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">2.001,00</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">2.001,00</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">2.001,00</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">2.001,00</td> <td style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class="xl24">2.001,00</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 12.75pt" height="17"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="17">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl22">TotalHaberes</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan" colspan="2">ImporteLiquido</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 12.75pt" height="17"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="17">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl22"><=1227</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 12.75pt" height="17"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="17">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl22">TotalHaberes</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl22">TotalHaberes</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan" colspan="2">ImporteLiquido</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">>1227</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23"><=2000</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 12.75pt" height="17"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="17">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl22">TotalHaberes</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl22">TotalHaberes</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan" colspan="2">ImporteLiquido</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">>2000</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23"><=3000</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 12.75pt" height="17"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="17">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl22">TotalHaberes</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl22">TotalHaberes</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan" colspan="2">ImporteLiquido</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">>3000</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23"><=5000</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 12.75pt" height="17"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="17">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl22">TotalHaberes</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl22">TotalHaberes</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan" colspan="2">ImporteLiquido</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">>5000</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23"><=8944</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 12.75pt" height="17"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="17">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl22">TotalHaberes</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan" colspan="2">ImporteLiquido</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr> <tr style="HEIGHT: 11.25pt" height="15"> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 11.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23" height="15">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">>8944</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td> <td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class="xl23">
</td></tr></tbody></table>
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,223,952
Messages
6,175,594
Members
452,656
Latest member
earth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top