Excel - Sumar celdas de una columna SI en otra columna hay determinado valor

Asked By Peter on 11-Jul-08 09:57 AM
Hola:
A ver si alguien puede ayudarme.

En A1 pongo un 5 - En B1 pongo 7880
En A2 pongo un 8 - En B2 pongo 8559
En A3 pongo un 5 - En B1 pongo 7880
En A4 pongo un 8 - En B2 pongo 8559

Quiero crear una fórmula para que sume todos los valores de la columna A
siempre que en la B correspondiente haya un determinado valor.

Por ejemplo en A6:
Si en B dice 7880 entonces sumar los valores que aparezcan al lado en A (A1
+ A3 = 10)

O en este otro caso en A7:
Si en B dice 8559 entonces sumar los valores que aparezcan al lado en A (A2
+ A4 = 16)

¿Cómo se hace?
¿Qué fórmula debo poner en A6 y en A7?
Muchas gracias y saludos
Peter





begin 666 Ejemplo Excel.jpg
M_]C_X `02D9)1@`!`0$`8 !@``#_VP!#``,"`@,"`@,#`P,$`P,$!0@%!00$
M!0H'!P8(# H,# L*"PL-#A(0#0X1#@L+$!80$1,4%145# \7&!84&!(4%13_
MVP!#`0,$! 4$!0D%!0D4#0L-%!04%!04%!04%!04%!04%!04%!04%!04%!04
M%!04%!04%!04%!04%!04%!04%!04%!3_P `1" "+`+L#`2(``A$!`Q$!_\0`
M'P```04!`0$!`0$```````````$"`P0%!@<("0H+_\0`M1 ``@$#`P($`P4%
M! 0```%]`0(#``01!1(A,4$&$U%A!R)Q%#*!D:$((T*QP152T? D,V)R@@D*
M%A<8&1HE)B<H*2HT-38W.#DZ0T1%1D=(24I35%565UA96F-D969G:&EJ<W1U
M=G=X>7J#A(6&AXB)BI*3E)66EYB9FJ*CI*6FIZBIJK*SM+6VM[BYNL+#Q,7&
MQ\C)RM+3U-76U]C9VN'BX^3EYN?HZ>KQ\O/T]?;W^/GZ_\0`'P$``P$!`0$!
M`0$!`0````````$"`P0%!@<("0H+_\0`M1$``@$"! 0#! <%! 0``0)W``$"
M`Q$$!2$Q!A)!40=A<1,B,H$(%$*1H;'!"2,S4O 58G+1"A8D-.$E\1<8&1HF
M)R@I*C4V-S@Y.D-$149'2$E*4U155E=865IC9&5F9VAI:G-T=79W>'EZ@H.$
MA8:'B(F*DI.4E9:7F)F:HJ.DI::GJ*FJLK.TM;:WN+FZPL/$Q<;'R,G*TM/4
MU=;7V-G:XN/DY>;GZ.GJ\O/T]?;W^/GZ_]H`# ,!``(1`Q$`/P#[=_X4-X+_
M`.?"^_\`!Q>__'J/^%#>"_\`GPOO_!Q>_P#QZO0**\PZ#S__`(4-X+_Y\+[_
M`,'%[_\`'JP_!WP8\)ZKI%Q-=6E]+*NHW\ ;^UKP82.[FC0<2]E11GJ<<\UZ
MY7-?#W_D`W7_`&%M3_\`2^>@#$_X4-X+_P"?"^_\'%[_`/'J/^%#>"_^?"^_
M\'%[_P#'J] HH \__P"%#>"_^?"^_P#!Q>__`!ZD?X$^"8U+-8WRJHR2=8O<
M`?\`?ZO0:\Z^/<?B#5?A[<>'?#"SQ:QXDF31DU"*!Y4TZ*7(GNI-K*5$<0D(
M.Y<OL4$%A2=]H[L<4KZ[?IU.1^%7A_X7_&'P_<ZQH.GZNEM!<M;,EWJEVCGY
M$DCD`$Y^22*2*5#G)61<A3E1V?\`PH;P7_SX7W_@XO?_`(]7$^!?!OC7X8?%
MZREU6\TK6_#WB'3$TID\->'[BPM].GLU9K=Y%:XN<*\321;RR*#%"N"6%>[5
MK-1T<=OZ7X[_`#(5_M+^O^!M\CS_`/X4-X+_`.?"^_\`!Q>__'J/^%#>"_\`
MGPOO_!Q>_P#QZO0**S*//_\`A0W@O_GPOO\`P<7O_P`>K#\'?!CPGJND7$UU
M:7TLJZC?P!O[6O!A([N:-!Q+V5%&>IQSS7KE<U\/?^0#=?\`86U/_P!+YZ ,
M3_A0W@O_`)\+[_P<7O\`\>H_X4-X+_Y\+[_P<7O_`,>KT"B@#S__`(4-X+_Y
M\+[_`,'%[_\`'JY;XD^!? 7PT\+G6KCP]KNL9N[6QAL=,UB?SYYKB=((E7S;
MJ-!EY%R6=0!DYKVFO)/VI-)?6?A/Y L]6OH$UO1Y[F/0HKF2\6WCU&W>9XA;
M`S!EC5FS%\XVY'(IK644]FTODVKE12;.:\)Z'X,U[Q?'X9UGP!XO\%ZQ<6<E
M_9Q:WK'F)>11NB2F.2TOIU!0RQ95RI(<$ @-CT#_`(4-X+_Y\+[_`,'%[_\`
M'J\Y^%7A[3I/C3::YX/MO' T*'0[NRU:Y\;G6-QE>:W>V2W_`+5_>]$G+>5\
MGW=^6V8^AJN22C%]7>_WM+\+/YW,UN_ZZ+]3S_\`X4-X+_Y\+[_P<7O_`,>H
M_P"%#>"_^?"^_P#!Q>__`!ZO0**S*//_`/A0W@O_`)\+[_P<7O\`\>K#\'?!
MCPGJND7$UU:7TLJZC?P!O[6O!A([N:-!Q+V5%&>IQSS7KE<U\/?^0#=?]A;4
M_P#TOGH`/^$3U3_H=-<_[\V'_P`C5A:W>VOAOQ#X?T+4OB/JUKK'B":6#3+)
MH;$R7311-+)M`M3@*BDEC@#*C.64'T*O&/BKX5T:S^,OPDU^'2[./7+SQ#+;
MW&I+"OVB6)-)U#9&9,;B@))"YP"2<9)JH13DDQVTD^R;^Y7/0O\`A$]4_P"A
MTUS_`+\V'_R-5?X:_#^[U'PS+/\`\)AKEL3JFI*4ACL=I*WTZEOFMB<L1N/.
M,DX`& .MI_PC_P"1.D_["VJ_^G"XJZ44Y69G+0@_X5C>?]#OXA_[]:?_`/(M
M'_"L;S_H=_$/_?K3_P#Y%KNJ*ZO9Q[&=V<+_`,*QO/\`H=_$/_?K3_\`Y%H_
MX5C>?]#OXA_[]:?_`/(M=U11[./8+LX7_A6-Y_T._B'_`+]:?_\`(M'_``K&
M\_Z'?Q#_`-^M/_\`D6NZHH]G'L%V<+_PK&\_Z'?Q#_WZT_\`^1:/^%8WG_0[
M^(?^_6G_`/R+7=44>SCV"[/%+"]TG5?'=[X1L_&WCFYU>RD,-S+'X<!L(9!$
MLI1KW^SOLP;8ZG;YF<L!C)Q6WX7^%LT.FS+#XRU^%#>WC%5CL2"QN9"S<VQ.
M222>W/ `P*\M^'GB:+P]\6X=$\+_`!+;QEJ&J>*-4D\1>#I+.UM7T>V;[3+]
MI> Q"\0I(MK"LLLABD212B_O(R/HWPU_R#IO^OV[_P#2B2FJ4>2,FM6OQZV\
MNW^=QR;C.4;][>EVM?/38YK_`(5C>?\`0[^(?^_6G_\`R+1_PK&\_P"AW\0_
M]^M/_P#D6NZHI>SCV%=G"_\`"L;S_H=_$/\`WZT__P"1:/\`A6-Y_P!#OXA_
M[]:?_P#(M=U11[./8+LX7_A6-Y_T._B'_OUI_P#\BUR'CV;3_AM]F.L^+?B#
M.MPCNKZ+X6.K*BIC<9&M--E$?7C?C/.,X./::\I_:-)U?P;I/A /L3QCK-KH
M-P`Q!>T<M+=H,$'YK:&=?;=GM4NFM$EJVE\V[+\2D]W+9)M^BU?X'"W7Q7^'
M]GHVA:O+\5?%7]F:S81:M!=)H:ND%E(VV.ZNB-//V2%CG$MQY:$*Q!PK$;&L
M>*?">@^-8?"M]\3_`!+%JTD\%H732X)+.&XF&8()KM;$P0RR`KLCDD5VWI@'
M>N?+_P!J[4[/PUXJ\7V<NLVWA/[9X)AM=(TE8@3XSF66Z7^RBN=[JOF1(([4
MQ3_Z83YFW %/Q]K45E\6=:T>?4;72]:O/%GAR:R^'"QAAX@@VV6_467/G,8/
M*E^>%DA06 \Y)!G.T*5.I**2T<K?+FM]]M_/=):A)2BG?>U_G:+^Z[ZVTZWN
MCV6PUCPWJ?Q F\%6WQ,\22>((C(IC_LZV%N\D:JTL*7)L?)>9%=6:)7+J"25
M`!QO^%_A;-#ILRP^,M?A0WMXQ58[$@L;F0LW-L3DDDGMSP`,"O$?!>K65SX\
M\%^ HKJ)_'&@_$?Q!KNK:8K#[3:Z?*NI/'=2+]X12+?6@5SPQE"@Y! ^J?#7
M_(.F_P"OV[_]*)*CV4.6,M[_`(^:\O\`()^[4<4[VO\`FU^23]&O5^<_8/&/
M_0=T/_P2S?\`R77/:AXUFTGQ78^%[[XB>"K+Q-?)YEIHUQ:&.\N%^;YHX3>[
MV'R-R ?NGT->C5X-XV\.:9X_\:ZKX+\,:6HDEUG3]<\7^(G)=;26W\B2W@CW
MYW7+I;P@*F%AC;S#AF19.",>:23V_K]/QLNIJ](MGJGV#QC_`-!W0_\`P2S?
M_)=:GPDM];_X0P_\3"PW#5-3#'["^"WV^XW$?ON 3D@<X! R<9.C3_A'_P`B
M=)_V%M5_].%Q6M'XB)[&]]FUO_H(Z?\`^ #_`/QZC[-K?_01T_\`\ '_`/CU
M:M%=ID97V;6_^@CI_P#X`/\`_'J/LVM_]!'3_P#P`?\`^/5JT4 97V;6_P#H
M(Z?_`. #_P#QZC[-K?\`T$=/_P# !_\`X]6K10!E?9M;_P"@CI__`( /_P#'
MJ/LVM_\`01T__P``'_\`CU:M% '$6GC[3M0\97?A&U\<>%KGQ79Q>?<Z%"5>
M^@CPIWO +C>JX=#DC'S+ZBK_`(?M]8-A+Y=]8JOVNZR&LG8Y\^3)_P!:."<G
M';ISUKYB\'DI\2O ]Q-%IZZ!+\2?$4.FZ2K$:M:7_EZB9[F:<C]["X$K>0$1
MD6:$M-*%VGZP\-?\@Z;_`*_;O_THDII>Y&7=?\']?ZV3FN6I*':_X-K\U_PZ
MLV?9M;_Z".G_`/@`_P#\>H^S:W_T$=/_`/ !_P#X]6K12$97V;6_^@CI_P#X
M`/\`_'J/LVM_]!'3_P#P`?\`^/5JT4 97V;6_P#H(Z?_`. #_P#QZN?\:>.K
M'X;Z;%J/BWQMX7\+:?+*(([O6MMG$\A!(0/)<*"Q"DX!S@'TKM:\$^.T.H7?
MQ?\`!$&ASZ3I6MMH.N,NJ^(83<V"VP-GYT'D!D+2/\C"3S $2*0E)0=HB<N5
M7]?P3?Z?Y)O1W"*D[,[OQA\3]#^'K:<OBGXA>#_#1U+/V(:Q*EI]JQC/E>9<
MC?C<OW<_>'K3M:^)NB^&_%.G^&=6^(/A#2_$FHA#9:/>RI#>7(=BJ>7"UR'?
M<P(&T')!`KYQ\$:QK/AOX;Z!\0O!NI>'+71?"_PPTVX'A75&EU+5#;[)9WB#
MQR0+`)Q!"B7!C<,86(B 7:?0+_7_`!3X+\>^+/'-EJWAK5M#OM=T71KKP_!!
M-<:K`DJVL"Q/.)E2VDC>[EN/*,,FY''S+ORO3*DXU/9];M?^367WZ?\`#:N+
M.U^ZT];)O[K]_._0]9L?&UGJGBR_\+6?C3PS=^)M/C$UYHL`#WMM&=I#R0BX
MWHIW+@D`?,/45;\/V^L&PE\N^L57[7=9#63L<^?)D_ZT<$Y..W3GK7SA;^'M
M9\*?$SX?:3I]YX;U'1IOB+K.I0:II=V\NHW/G0:A+>07,80)%Y#.(F82R;S'
M$&2,\#ZB\-?\@Z;_`*_;O_THDK):Q3_K9/\`6WR'-<M1QZ?\%K[]+VZ7MN><
M_;_&/_0"T/\`\'4W_P`B5PU_\&-%U7Q(WB*]^#_PXO/$#3K=-JLX1[HS`@K(
M938[MX(!#9SP*]>KY[_:#^'VEZ/XA\.^-[;P]8+J#^(=*34/%IN'?6-/C-W!
M#'#:*RD"&0N4E198U"2RMY<K.P/FP5ZD5>UVE?U:-VKQ?Y=SU_[?XQ_Z`6A_
M^#J;_P"1*U/A)<:W_P`(8?\`B7V&XZIJ98?;GP&^WW&X#]SR`<@'C( .!G T
M:?\`"/\`Y$Z3_L+:K_Z<+BM*/Q$3V-[[3K?_`$#M/_\``]__`(S1]IUO_H':
M?_X'O_\`&:U:*[3(ROM.M_\`0.T__P`#W_\`C-'VG6_^@=I__@>__P`9K5HH
M`ROM.M_]`[3_`/P/?_XS1]IUO_H':?\`^![_`/QFM6B@#*^TZW_T#M/_`/ ]
M_P#XS1]IUO\`Z!VG_P#@>_\`\9K5HH XBT\`Z=I_C*[\76O@?PM;>*[R+R+G
M780J7T\>%&QYQ;[V7"(,$X^5?05?\/W&L"PE\NQL67[7=9+7KJ<^?)D?ZH\`
MY&>_7CI7AO@W0'\#?&H^(_&GPR\-VVL^+?$U_8Z5XN6XBN=:0"*8VR,HM_W4
M#6EI_#<,P9P&C&YBOT+X:_Y!TW_7[=_^E$E-?!%^7W=U\AR3C-I_\.KM7^=M
M`^TZW_T#M/\`_ ]__C-'VG6_^@=I_P#X'O\`_&:U:*0C*^TZW_T#M/\`_ ]_
M_C-'VG6_^@=I_P#X'O\`_&:U:* ,K[3K?_0.T_\`\#W_`/C-<_XT\"V/Q(TV
M+3O%O@GPOXIT^*43QVFM;;R)) " X22W8!@&(R!G!/K7:UXA^U=X(\,>+O D
M$>I^$_#WB'Q-?W4.A:'>:WH]OJ#6$UW*D;31B9& \M<RD=#Y(R#4MM6LM;JW
MKT_&Q4;;MV_RZ_@=IK_PYTGQ7J^CZKK?@+PGK&J:,P?3+Z_1)Y[%@P8&!WMR
MT9#*I!4CE0>U.N?A[IEYXTMO&%QX$\*3^+;:/R8-?D56OXDVLNU9S;^8HVNP
MP&QAB.YKY5^._P`+/#_A<:YX>T+PO#JNC^ _A_:217%W*%N/"L*R796^THDY
MDOF\AG8%H,_9HLSDG:+WCO3;+4_BOKGBT:5_:$.D>+O#MD_C>9U76='9TL,6
M=E'_`!6DHN%\XF2+'VN?]S/CG>$>:48Q?5_*[Y;_`#O^B;8G%Q3NM;?C9.WX
M_K:S/J#3O MCH_BS4?%-AX)\+V7B;44$5[K5OMCO;I!MPLLPMP[@;%X8G[H]
M!5WP_<:P+"7R[&Q9?M=UDM>NISY\F1_JCP#D9[]>.E?-G@[3K:+QUX(\>) @
M\;:W\1O$&@:GJ6/](N-.C&I+':.>IAC6RM65#PIC# 9))^IO#7_(.F_Z_;O_
M`-*)*BS45?\`KKIY:CG%PFXOS_!N/YQ?RL><_P#"6:I_T)>N?]_K#_Y)KBI_
M`^CW/C)_%#?#SQ,NIR3I=S11:Q%'97%PBA4GELUOA;RRJ$3$CQEQY<9!RBX]
M:KPSQUXUUO4OCE\.+/2=1EM/"]MK]QIFH) Q`U&Z_LR\E,;$'F.'9'D$$&1N
MQAY\R";E:+U_K_@?.QLU[LF]DF_N7_#GIW_"6:I_T)>N?]_K#_Y)K4^$FL7?
M_"&$_P!AW^6U34V(WV^5)O[@E3^]Z@G!QD9!P2,&M&G_``C_`.1.D_["VJ_^
MG"XK2C\1$]C>_MF[_P"@%J'_`'W;_P#QVC^V;O\`Z 6H?]]V_P#\=K5HKM,C
M*_MF[_Z 6H?]]V__`,=H_MF[_P"@%J'_`'W;_P#QVM6B@#*_MF[_`.@%J'_?
M=O\`_':/[9N_^@%J'_?=O_\`':U:* ,K^V;O_H!:A_WW;_\`QVC^V;O_`* 6
MH?\`?=O_`/':U:* /,/#_P`*_#7A?Q7+XATWPEK4%\\TURELVKM)86\TQ)FF
M@LWNC;P2.6<M)'&K'S),G]X^>G\/ZM=1V$H71;Z0?:[HY5X,`F>0D<RCD=#]
M.,CFOG'P;XDU>;XXZ-?/KWB9DO\`Q=K.E3:Q<WT[^']4@B2Z\O3;:R+%8)X#
M!'F?R8E<VTV)YC)M;ZA\-?\`(.F_Z_;O_P!*)*>\(ONON_K^M-6Y+EJ2B]_^
M"U^:?ZZW2/[9N_\`H!:A_P!]V_\`\=H_MF[_`.@%J'_?=O\`_':U:*0C*_MF
M[_Z 6H?]]V__`,=H_MF[_P"@%J'_`'W;_P#QVM6B@#*_MF[_`.@%J'_?=O\`
M_':R=<T^W\27.CW&H^&=0N)=(O!J%D?M$*B.<1O&'(6<!L+*XPV1D@XR`1U=
M?/\`^TK=WEUXM\(Z)#)XJU2UN=/U.[D\/>"=3ETS49GC^SJEV;E)81Y,/FL#
M$THWM-&1'*5VB)24;-_U;7]/ENVE=JX1YFU_7],Z_P"(/PF\+?%+4K:^\2^#
M=6OIX8?LSK#JAMHKJ#>'\BYCAN42YAW#/E3!TY;Y?F;*:U\(_"GB'QM;^++_
M`,%ZK/J\,L$^P:F4LY9H,^1-+:+<B"66/(V221LR[4VD;5QX?/XOU#6]*\#Z
M]XK/CKQ7X0TGP/9ZOJ7BGP?J5SHEC+-+EY[R?;<VDDPCCMMQA2-W`F/[D%@M
M=AK6OA?CIJ>N>)]*\>P>%K&^TO2M)UFQUF>QT.-Y%C*22VR7D9NA+<7:0EA;
MS(/+`8@*Y'1R.$E!;J3^6MKKS;V[W[W2A\S3TW2^=TG;Y)JZW7:VIZ+IOPN\
M,Z1\0KGQM:^#=5C\0W#22-(VI;[9)9$1)9H[5KDP1RNL:JTJ1J[#(+'<<]+X
M?U:ZCL)0NBWT@^UW1RKP8!,\A(YE'(Z'Z<9'-?.NB>*?$WA3XRZ(NJR>,F\1
MZSXTO]+U.+4#='0CI+Q7<EA]C5R+4L(X+5BUOF8$3>=U(KZ=\-?\@Z;_`*_;
MO_THDK)?!%K;;TT3M\KH<URU)1>_YZM7^=G;RL^IYS_PL+2_^?77/_!!?_\`
MQFO+O$'PD^#?B/QEI'BF?X?+!KNGZFVK->6_@J59;R<QR+FX<VA:3#2>8#D'
MS$1L\5[M7@UY\2CJ'Q[U;2;KQMXA\/:3H]W8Z;%I^GZ-'+IMU<R1K,RW=[)9
M2+"9/M$$2()XF)X7YF%>=#F<TH[_`-?\`W=^5]CU3_A86E_\^NN?^""__P#C
M-:GPD\26G_"&$^3?X?5-3<?\2ZXSAK^X(S\G!P>0>0<@@$$5HT_X1_\`(G2?
M]A;5?_3A<5I1^(B>QO?\)+:?\\=0_P#!=<?_`!NC_A);3_GCJ'_@NN/_`(W6
MK17:9&5_PDMI_P`\=0_\%UQ_\;H_X26T_P">.H?^"ZX_^-UJT4 97_"2VG_/
M'4/_``77'_QNC_A);3_GCJ'_`(+KC_XW6K10!E?\)+:?\\=0_P#!=<?_`!NC
M_A);3_GCJ'_@NN/_`(W6K10!XOI7P?\`#6E>.[?Q"NK>+)]/L]2N=:L/#,MF
MPTRRO[A'6:YC"VPF9F\Z<[9)7C5IG*H#@CT#P_X@M8K"56BOB3=W3?+83L,&
M>0CD)UYY';H>:ZBLKPU_R#IO^OV[_P#2B2CHEV&W=N3W_I_G=^K;ZA_PDMI_
MSQU#_P`%UQ_\;H_X26T_YXZA_P""ZX_^-UJT4",K_A);3_GCJ'_@NN/_`(W1
M_P`)+:?\\=0_\%UQ_P#&ZU:*`,K_`(26T_YXZA_X+KC_`.-UPGQ)\%Z;\0[W
M2]2MM=\5^$-<TZ.>WAU?P_88N#;S!1- PN+69"C&.)L[-P:-2K#!SZA12:3W
M&FUJCP_4/@KX<FT73M TWQ!XUT+PE;Z5#H=WX;M(7FLM0LHP5$4HN+:5XRR,
MZ/) \4CAOF<E4*Z>K_#?2M;\3_;[KQ'XRET!KNWOY/"4EH9=+>X@V&%QYEJT
M\2J\44GE13)&63)0[WW^NT5ISR;YF]=_U_/5=GJA=+'D]G\/M*B\?P^)[[Q!
MXQUN.RN9[W3-%U.V>6RTRXF1DDDA(MQ,?E>55665TC61E14&T#L/#_B"UBL)
M5:*^)-W=-\MA.PP9Y".0G7GD=NAYKJ*RO#7_`"#IO^OV[_\`2B2HZ)!NV^YY
MS_PL[P=_T-FA_P#@RA_^*KS7Q:;'QCKS0:A\6?#-QX(DO[34GT:6*'[;%);O
M'+''%=I<*JQ&6%'(>&1SND42`%=GM]>(:A\9]9U#XR7?A?2->\%:1;:?J,&F
MC1]?F=-3UIS#%/=-:,LHV"**=,#R9=[JP)C'S5YT.;G7+O\`\%:_?8Z'I%L]
M*_X6=X._Z&S0_P#P90__`!5:GPD\5Z(/!A;^V+#:^J:G(I^U)AE:_N&5ASR"
M""#W!%:-/^$?_(G2?]A;5?\`TX7%:4?B(GL;W_"6:)_T&=/_`/ I/\:/^$LT
M3_H,Z?\`^!2?XUJT5VF1E?\`"6:)_P!!G3__``*3_&C_`(2S1/\`H,Z?_P"!
M2?XUJT4`97_"6:)_T&=/_P# I/\`&C_A+-$_Z#.G_P#@4G^-:M% &5_PEFB?
M]!G3_P#P*3_&C_A+-$_Z#.G_`/@4G^-:M>3^.OBQXD\.?&3X?^$[+PN?^$=U
MS4)K._\`$-[*@0L+&XN$BMHU?>6S!\[NH0#Y5WLQ,;2NTD.VC?9-_=J>A_\`
M"6:)_P!!G3__``*3_&LSP_XFT>&PE635K&-C=W3 -<H#@SR$'KT((/XUY?X?
M^-_BC4_'NC7-Q;Z0O@+7?$>I>%+&WB@E&HPW-HMQBYDF,AC:.1[*Y7RA$I4-
M$V]OF ]C\-?\@Z;_`*_;O_THDHMHGW_K^OQU"2<9.+W7Z-K\TU\@_P"$LT3_
M`*#.G_\`@4G^-'_"6:)_T&=/_P# I/\`&M6BD(RO^$LT3_H,Z?\`^!2?XT?\
M)9HG_09T_P#\"D_QK5HH`RO^$LT3_H,Z?_X%)_C1_P`)9HG_`$&=/_\``I/\
M:U:*`,K_`(2S1/\`H,Z?_P"!2?XT?\)9HG_09T__`,"D_P`:U:* ,K_A+-$_
MZ#.G_P#@4G^-9GA_Q-H\-A*LFK6,;&[NF :Y0'!GD(/7H00?QKJ*RO#7_(.F
M_P"OV[_]*)* .>KP?QA\"M<U'Q/K\&DV^@-X>\4:]IVOZIJ=[(ZZC9RVIM_W
M<$2PE9MPM4VN\J&,R.<.``?4_P#A6/@[_H4]#_\`!;#_`/$UY)\1I+GP/XNT
M33;/X0^ ]9T_6]4ATW3V&IF&^D!7?-*UO_9S1JL2+*[?OCE4&#N95KS87YUR
M[Z?FG^:3^1O+X7?;_@/7[KGT!3_A'_R)TG_86U7_`-.%Q7+_`/"L?!W_`$*>
MA_\`@MA_^)K4^$GA31#X,*_V/8;4U34XU'V5,*JW]PJJ.. ```.P`K6C\1,]
MCT>BLK_A$]$_Z VG_P#@*G^%'_")Z)_T!M/_`/ 5/\*[3(U:*RO^$3T3_H#:
M?_X"I_A1_P`(GHG_`$!M/_\``5/\* -6BLK_`(1/1/\`H#:?_P" J?X4?\(G
MHG_0&T__`,!4_P`*`-6N'^('@>_\5^+OASJMI+;QV_AS6I=2NUF9@[QM87=L
M!& I!;?<(<$@8#<YP#T?_")Z)_T!M/\`_ 5/\*\S\7?$3PUX9^+7@WP'#X)D
MU"XUZZEMKC5?[-\JQL-MI-<H/.:/9-*X@(\N,DJ,LY7Y`]1OS)+<I7M+T=_2
MSO\`@8OASX(^*]-\?Z5;7<VC?\(#H7B74O%>GW,-S*VI3W%VL_\`HTL)B$:)
M&][=-YBRL6"Q#8OS&O9O#7_(.F_Z_;O_`-*)*\M\)>++KQKXON5TOX8Z5/X$
MAU2[T<^(?MT*W7G6Q=)9?L9A`\CSHWA#+,9"0&\K:=P[_P`/^&='FL)6DTFQ
MD87=TH+6R$X$\@`Z= `!^%*[Y8_T_GYVL*;;G)RWU_-M_BV[=+]CJ**RO^$3
MT3_H#:?_`. J?X4?\(GHG_0&T_\`\!4_PI"-6BLK_A$]$_Z VG_^`J?X4?\`
M")Z)_P! ;3__``%3_"@#5HK*_P"$3T3_`* VG_\`@*G^%'_")Z)_T!M/_P#
M5/\`"@#5HK*_X1/1/^@-I_\`X"I_A1_PB>B?] ;3_P#P%3_"@#5K*\-?\@Z;
M_K]N_P#THDH_X1/1/^@-I_\`X"I_A69X?\,Z/-82M)I-C(PN[I06MD)P)Y !
MTZ `#\* *-<)/X9U+4?C?:Z[<VQ_L72M!>VLIS(I5KJXG!FPF=P*QV\/S$8Q
M(0"?FQK?\*]TO_GZUS_P?W__`,>H_P"%>Z7_`,_6N?\`@_O_`/X]7F*Z:EVO
M^*:_4Z'JFN]OP:?Z6]#I:?\`"/\`Y$Z3_L+:K_Z<+BN7_P"%>Z7_`,_6N?\`
M@_O_`/X]6I\)/#=I_P`(81YU_A-4U-!_Q,;C.%O[@#/S\G Y)Y)R22236U'X
MB)['H]%97_"-6G_/;4/_``8W'_QRC_A&K3_GMJ'_`(,;C_XY7:9&K165_P`(
MU:?\]M0_\&-Q_P#'*/\`A&K3_GMJ'_@QN/\`XY0!JT5E?\(U:?\`/;4/_!C<
M?_'*/^$:M/\`GMJ'_@QN/_CE`&K7G?Q,\*:KXA\<?"O4-/M?M%IHFOSWM_)Y
MB+Y,+:;>P!L,06_>31KA<GYLXP"1U_\`PC5I_P`]M0_\&-Q_\<H_X1JT_P">
MVH?^#&X_^.4T[.XT[)KNFOO5CYK\'? +4_"?Q7T%K/P4;6]T[Q'J>KWGQ$6[
M@ O=,N6NI5T_:)3<M^\N(P87C$"F(R*V[:#]*>&O^0=-_P!?MW_Z424?\(U:
M?\]M0_\`!C<?_'*S/#_A^UEL)6:6^!%W=+\M_.HP)Y .`_7CD]^IYI+2*C_7
M]:;*RZVNV)ZR<OZW;_7^K'445E?\(U:?\]M0_P#!C<?_`!RC_A&K3_GMJ'_@
MQN/_`(Y0!JT5E?\`"-6G_/;4/_!C<?\`QRC_`(1JT_Y[:A_X,;C_`..4`:M%
M97_"-6G_`#VU#_P8W'_QRC_A&K3_`)[:A_X,;C_XY0!JT5E?\(U:?\]M0_\`
M!C<?_'*/^$:M/^>VH?\`@QN/_CE &K65X:_Y!TW_`%^W?_I1)1_PC5I_SVU#
H_P`&-Q_\<K,\/^'[66PE9I;X$7=TORW\ZC GD X#]>.3WZGF@#__V0``
`
end




Infinitogool replied on 11-Jul-08 10:44 AM
Hola Peter

en A6 puedes pones
=SUMAR.SI($B$1:$B$4;B6;$A$1:$A$4)
y arrastrar/copiar hacia abajo
o
=SUMAPRODUCTO(($B$1:$B$4=B6)*($A$1:$A$4))
y arrastrar/copiar hacia abajo

un saludo
Pedro J.
Peter replied on 11-Jul-08 12:31 PM
Hola tocayo:
Muchas gracias por tu rápida respuesta.
He copiado y pegado tu fórmula pero me da 0 (cero)

Aquí te pongo otro ejemplo por si no lo expliqué bien

5   Paca
8   Pepe
5   Paca
8   Pepe

Quiero que en A6 sume todas las "Pacas" o sea 5+5 = 10

y en otra celda (A7) sume todos los "Pepes" o sea 8+8 = 16

¿Está mejor explicado ahora?
Gracias y saludos
Peter






begin 666 Ejemplo Excel 2.jpg
M_]C_X `02D9)1@`!`0$`8 !@``#_VP!#``,"`@,"`@,#`P,$`P,$!0@%!00$
M!0H'!P8(# H,# L*"PL-#A(0#0X1#@L+$!80$1,4%145# \7&!84&!(4%13_
MVP!#`0,$! 4$!0D%!0D4#0L-%!04%!04%!04%!04%!04%!04%!04%!04%!04
M%!04%!04%!04%!04%!04%!04%!04%!3_P `1" "+`+L#`2(``A$!`Q$!_\0`
M'P```04!`0$!`0$```````````$"`P0%!@<("0H+_\0`M1 ``@$#`P($`P4%
M! 0```%]`0(#``01!1(A,4$&$U%A!R)Q%#*!D:$((T*QP152T? D,V)R@@D*
M%A<8&1HE)B<H*2HT-38W.#DZ0T1%1D=(24I35%565UA96F-D969G:&EJ<W1U
M=G=X>7J#A(6&AXB)BI*3E)66EYB9FJ*CI*6FIZBIJK*SM+6VM[BYNL+#Q,7&
MQ\C)RM+3U-76U]C9VN'BX^3EYN?HZ>KQ\O/T]?;W^/GZ_\0`'P$``P$!`0$!
M`0$!`0````````$"`P0%!@<("0H+_\0`M1$``@$"! 0#! <%! 0``0)W``$"
M`Q$$!2$Q!A)!40=A<1,B,H$(%$*1H;'!"2,S4O 58G+1"A8D-.$E\1<8&1HF
M)R@I*C4V-S@Y.D-$149'2$E*4U155E=865IC9&5F9VAI:G-T=79W>'EZ@H.$
MA8:'B(F*DI.4E9:7F)F:HJ.DI::GJ*FJLK.TM;:WN+FZPL/$Q<;'R,G*TM/4
MU=;7V-G:XN/DY>;GZ.GJ\O/T]?;W^/GZ_]H`# ,!``(1`Q$`/P#[=_X4-X+_
M`.?"^_\`!Q>__'J/^%#>"_\`GPOO_!Q>_P#QZO0**\PZ#S__`(4-X+_Y\+[_
M`,'%[_\`'JP_!WP8\)ZKI%Q-=6E]+*NHW\ ;^UKP82.[FC0<2]E11GJ<<\UZ
MY7-?#W_D`W7_`&%M3_\`2^>@#$_X4-X+_P"?"^_\'%[_`/'J/^%#>"_^?"^_
M\'%[_P#'J] HH \__P"%#>"_^?"^_P#!Q>__`!ZD?X$^"8U+-8WRJHR2=8O<
M`?\`?ZO0:\Z^/<?B#5?A[<>'?#"SQ:QXDF31DU"*!Y4TZ*7(GNI-K*5$<0D(
M.Y<OL4$%A2=]H[L<4KZ[?IU.1^%7A_X7_&'P_<ZQH.GZNEM!<M;,EWJEVCGY
M$DCD`$Y^22*2*5#G)61<A3E1V?\`PH;P7_SX7W_@XO?_`(]7$^!?!OC7X8?%
MZREU6\TK6_#WB'3$TID\->'[BPM].GLU9K=Y%:XN<*\321;RR*#%"N"6%>[5
MK-1T<=OZ7X[_`#(5_M+^O^!M\CS_`/X4-X+_`.?"^_\`!Q>__'J/^%#>"_\`
MGPOO_!Q>_P#QZO0**S*//_\`A0W@O_GPOO\`P<7O_P`>K#\'?!CPGJND7$UU
M:7TLJZC?P!O[6O!A([N:-!Q+V5%&>IQSS7KE<U\/?^0#=?\`86U/_P!+YZ ,
M3_A0W@O_`)\+[_P<7O\`\>H_X4-X+_Y\+[_P<7O_`,>KT"B@#S__`(4-X+_Y
M\+[_`,'%[_\`'JY;XD^!? 7PT\+G6KCP]KNL9N[6QAL=,UB?SYYKB=((E7S;
MJ-!EY%R6=0!DYKVFO)/VI-)?6?A/Y L]6OH$UO1Y[F/0HKF2\6WCU&W>9XA;
M`S!EC5FS%\XVY'(IK644]FTODVKE12;.:\)Z'X,U[Q?'X9UGP!XO\%ZQ<6<E
M_9Q:WK'F)>11NB2F.2TOIU!0RQ95RI(<$ @-CT#_`(4-X+_Y\+[_`,'%[_\`
M'J\Y^%7A[3I/C3::YX/MO' T*'0[NRU:Y\;G6-QE>:W>V2W_`+5_>]$G+>5\
MGW=^6V8^AJN22C%]7>_WM+\+/YW,UN_ZZ+]3S_\`X4-X+_Y\+[_P<7O_`,>H
M_P"%#>"_^?"^_P#!Q>__`!ZO0**S*//_`/A0W@O_`)\+[_P<7O\`\>K#\'?!
MCPGJND7$UU:7TLJZC?P!O[6O!A([N:-!Q+V5%&>IQSS7KE<U\/?^0#=?]A;4
M_P#TOGH`/^$3U3_H=-<_[\V'_P`C5A:W>VOAOQ#X?T+4OB/JUKK'B":6#3+)
MH;$R7311-+)M`M3@*BDEC@#*C.64'T*O&/BKX5T:S^,OPDU^'2[./7+SQ#+;
MW&I+"OVB6)-)U#9&9,;B@))"YP"2<9)JH13DDQVTD^R;^Y7/0O\`A$]4_P"A
MTUS_`+\V'_R-5?X:_#^[U'PS+/\`\)AKEL3JFI*4ACL=I*WTZEOFMB<L1N/.
M,DX`& .MI_PC_P"1.D_["VJ_^G"XJZ44Y69G+0@_X5C>?]#OXA_[]:?_`/(M
M'_"L;S_H=_$/_?K3_P#Y%KNJ*ZO9Q[&=V<+_`,*QO/\`H=_$/_?K3_\`Y%H_
MX5C>?]#OXA_[]:?_`/(M=U11[./8+LX7_A6-Y_T._B'_`+]:?_\`(M'_``K&
M\_Z'?Q#_`-^M/_\`D6NZHH]G'L%V<+_PK&\_Z'?Q#_WZT_\`^1:/^%8WG_0[
M^(?^_6G_`/R+7=44>SCV"[/%+"]TG5?'=[X1L_&WCFYU>RD,-S+'X<!L(9!$
MLI1KW^SOLP;8ZG;YF<L!C)Q6=K2Z+\*M#LI=8\;>+X%U/6+RTL[72=&34[BX
MN#+<3.%AM[&60DK'*Y.W:,'H,"N9^'GB:+P]\6X=$\+_`!+;QEJ&J>*-4D\1
M>#I+.UM7T>V;[3+]I> Q"\0I(MK"LLLABD212B_O(R-[XTVVMW>N_!^+PYJ.
MGZ5K+>-M2\B[U2P>]MX_]!U3=NA2:%FRN0,2+@D'G&"U1BXP=M6E?];>7;_/
M0TVG--Z)2:^5[7\]-5:YO> I=)^)/]H)HOCWQA'=:>Z)=6.KZ+%IEW#O&49K
M>ZL(Y=C ':^W:Q5@"2K =9_PK&\_Z'?Q#_WZT_\`^1:\F^*FA:G\,O OC?QU
MXX\6MJ&NZM#INAG4/"T3>'+:RM!=$1AYI);I[9#)=2F:Z#EHXV)C560$^.^!
MOB)=7.CZC9^(/&5WI/PQ3QPD&H:W8^-K^_AM+%](26%8];F6&X%M)>;?WVY5
MW,(U<J_S"ITY-I=+??=*W_DWYKLW'O)7]?717V]=.G?35+Z[_P"%8WG_`$._
MB'_OUI__`,BT?\*QO/\`H=_$/_?K3_\`Y%KYS^+/Q"\+6OA/X?Z3H_C;7=5T
MB]34Y],U36?'-[X<M=02*1$1!J4$#W5]*OF@6\:[Q.@:1FF*HQ]Z_9FU[4_$
M_P"SU\.=5UJ[GO\`5[K0K22\N;HDRR3>4H<N2 2V0<Y .<Y&:%2@U)VV:_7_
M`"!MII7W_K^OR-+_`(5C>?\`0[^(?^_6G_\`R+1_PK&\_P"AW\0_]^M/_P#D
M6NZHI>SCV%=G"_\`"L;S_H=_$/\`WZT__P"1:/\`A6-Y_P!#OXA_[]:?_P#(
MM=U11[./8+LX7_A6-Y_T._B'_OUI_P#\BUD^%_A;-#ILRP^,M?A0WMXQ58[$
M@L;F0LW-L3DDDGMSP ,"O4*RO#7_`"#IO^OV[_\`2B2CV<.P79YS]@\8_P#0
M=T/_`,$LW_R77/:AXUFTGQ78^%[[XB>"K+Q-?)YEIHUQ:&.\N%^;YHX3>[V'
MR-R ?NGT->C5X-XV\.:9X_\`&NJ^"_#&EJ))=9T_7/%_B)R76TEM_(DMX(]^
M=URZ6\("IA88V\PX9D63AC'FDD]OZ_3\;+J;O2+9ZI]@\8_]!W0__!+-_P#)
M=:GPDM];_P"$,/\`Q,+#<-4U,,?L+X+?;[C<1^^X!.2!S@$#)QDZ-/\`A'_R
M)TG_`&%M5_\`3A<5K1^(B>QO?9M;_P"@CI__`( /_P#'J/LVM_\`01T__P``
M'_\`CU:M%=ID97V;6_\`H(Z?_P" #_\`QZC[-K?_`$$=/_\``!__`(]6K10!
ME?9M;_Z".G_^`#__`!ZC[-K?_01T_P#\`'_^/5JT4 97V;6_^@CI_P#X`/\`
M_'J/LVM_]!'3_P#P`?\`^/5JT4 <1:>/M.U#QE=^$;7QQX6N?%=G%Y]SH4)5
M[Z"/"G>\`N-ZKAT.2,?,OJ*SM4\=Z;\-_#O]I>*O&GAGPGIDNH7,"76NLMK$
M\IFE)57DG4$G:Q"]<#O@FO O!Y*?$KP/<31:>N@2_$GQ%#INDJQ&K6E_Y>HF
M>YFG(_>PN!*WD!$9%FA+32A=I]!^--SK=IKOP?E\.:=I^JZROC;4O(M-4OWL
MK>3_`$'5-VZ9(9F7"Y(Q&V2 .,Y#2O"+[V_&S_7]?):.-JDX?RJ3_P# >9?G
M'_AU9OT_P5XZL/B5I<NI>$?&WA?Q5IT4QMY+S1-MY"DH`8H7CN& 8!E.,YPP
M]:Z#[-K?_01T_P#\`'_^/5\[_$.?XB_#K3?%WQ'O=-T[2_$NO2:'X:@TSPG?
M+J!AA-Z8S=":]BM8FN3]L=4$J")?+CW,X)4<ZGQ-^)JW7AOPKJGBC4O",M]X
MX703JNMIH<^LFTETJ6Y6*>.S,UK'/YP7RFV+E3#NC<%O,I+FV]/GI_\`))_A
MN1:UWV3?R2;_`$:_'9GU5]FUO_H(Z?\`^ #_`/QZC[-K?_01T_\`\ '_`/CU
M?*>H?
ZMJ>D>"]*OO$VLSPW&O0OXB\(V^AIJ%^+"Y@@C9UU!DM !Y["40
MKN+QC:(EW+7TC\'O$FK>,/A9X4UO7DLX]9O].AGO!I\\4UN92@W-&\4DB%2>
M1MD<8. S=3,?>@JBV=FO-.^OX=1/W9./573\FOZZ&W]FUO\`Z".G_P#@`_\`
M\>H^S:W_`-!'3_\`P ?_`./5JT4@,K[-K?\`T$=/_P# !_\`X]1]FUO_`*".
MG_\`@ __`,>K5HH`ROLVM_\`01T__P``'_\`CU9GA^WU@V$OEWUBJ_:[K(:R
M=CGSY,G_`%HX)R<=NG/6NHK*\-?\@Z;_`*_;O_THDH \Y^W^,?\`H!:'_P"#
MJ;_Y$KAK_P"#&BZKXD;Q%>_!_P"'%YX@:=;IM5G"/=&8$%9#*;'=O! (;.>!
M7KU?/?[0?P^TO1_$/AWQO;>'K!=0?Q#I2:AXM-P[ZQI\9NX(8X;164@0R%RD
MJ++&H265O+E9V!\Z"O4BKVNTK^K1T-7B_P`NYZ_]O\8_] +0_P#P=3?_`")6
MI\)+C6_^$,/_`!+[#<=4U,L/MSX#?;[C<!^YY .0#QD`' S@:-/^$?\`R)TG
M_86U7_TX7%:4?B(GL;WVG6_^@=I__@>__P`9H^TZW_T#M/\`_ ]__C-:M%=I
MD97VG6_^@=I__@>__P`9H^TZW_T#M/\`_ ]__C-:M% &5]IUO_H':?\`^![_
M`/QFC[3K?_0.T_\`\#W_`/C-:M% &5]IUO\`Z!VG_P#@>_\`\9H^TZW_`- [
M3_\`P/?_`.,UJT4`<1:>`=.T_P`97?BZU\#^%K;Q7>1>1<Z["%2^GCPHV/.+
M?>RX1!@G'RKZ"I-+T^YU"&VN)]#TF\FL=0N[BUFN;@E[>8R3(S1DPG:=KR)N
M!!*L1QN(KQCP;H#^!OC4?$?C3X9>&[;6?%OB:_L=*\7+<17.M(!%,;9&46_[
MJ!K2T_AN&8,X#1C<Q5?VD=,T_6/^%46FJ>"?^%B6,GC;4/,\-^39S?;,66ID
M?)=R1P':0'^=Q]SC)P"U?EB^]OEW7R_X.VI?*^::?12?JE?7T=K'O.K6-[K^
MEW>F:IH6CZEIUY$T%S9W=TTL,\;##(Z-`0RD$@@C!!KS;Q'^SUI&L6/@[1['
MP?X2TCPGH&IW&H2^&[>V06-ZLUI<V[Q-"(%103<ER2K9VX(YR.(\.Z;J'P=T
M?XA>*_#G@K2_@QH%S;6%KIWAK68X#;F_$CK+>_9-+DF5WD26")(8G$L[P*AV
M;D:H/!G[1_COQA))X6M_[(C\4S^*CH5IKFH^%]2TRV2W73%OWFETRYF6X$F-
MT2H9E#9$@;:-K-1NVHZZ:_>E^J_I-*;N*N]M5^&OGMIIUVZ,]DUGX4>'O$?A
M33_#&K?#CP;JGAK3BILM&O((YK.U*J57RX6MBB8!(&T#`)'>NJ@;5[6&.&'2
M]-BAC4(D:7KJJJ!@``0\`"O(/B?\2_'_`(!T'PQ8W&K^%K/Q3=_:VNWL?#>K
M:^]RD1 CDM]-LV$Z(P9#)(\K+ S*F92ZO7H?P3\=W7Q0^$'@SQ=?6L5E>ZWI
M-M?SV\!;RXY)(U9@N[YL9)QGG'6A)M2DNC5_G?\`R8FFN5-?U_7;0Z#[3K?_
M`$#M/_\``]__`(S1]IUO_H':?_X'O_\`&:U:*D#*^TZW_P! [3__``/?_P",
MT?:=;_Z!VG_^![__`!FM6B@#*^TZW_T#M/\`_ ]__C-9GA^XU@6$OEV-BR_:
M[K):]=3GSY,C_5'@'(SWZ\=*ZBLKPU_R#IO^OV[_`/2B2@#SG_A+-4_Z$O7/
M^_UA_P#)-<5/X'T>Y\9/XH;X>>)EU.2=+N:*+6(H[*XN$4*D\MFM\+>650B8
MD>,N/+C(.47'K5>&>.O&NMZE\<OAQ9Z3J,MIX7MM?N-,U!(&(&HW7]F7DIC8
M@\QP[(\@@@R-V,//G03<K1>O]?\``^=CH:]V3>R3?W+_`(<]._X2S5/^A+US
M_O\`6'_R36I\)-8N_P#A#"?[#O\`+:IJ;$;[?*DW]P2I_>]03@XR,@X)C
M3_A'_P`B=)_V%M5_].%Q6E'XB)[&]_;-W_T`M0_[[M__`([1_;-W_P! +4/^
M^[?_`..UJT5VF1E?VS=_] +4/^^[?_X[1_;-W_T`M0_[[M__`([6K10!E?VS
M=_\`0"U#_ONW_P#CM']LW?\`T M0_P"^[?\`^.UJT4 97]LW?_0"U#_ONW_^
M.T?VS=_]`+4/^^[?_P".UJT4`>8>'_A7X:\+^*Y?$.F^$M:@OGFFN4MFU=I+
M"WFF),TT%F]T;>"1RSEI(XU8^9)D_O'SHP:5::[)I%_?>&[Z\N]%U6\O["99
MXD$$[FXA8X$P#'RYI4(8$<Y'0&O!_!OB35YOCCHU\^O>)F2_\7:SI4VL7-].
M_A_5((DNO+TVVLBQ6"> P1YG\F)7-M-B>8R;6ZC]H35[?3;;X:VVI7OBBUT*
M^\8W\&HQ>$9=22^N(Q;:C(B :<?M+J)$C8A,CY<G@&J5^2#3WM\OZO\`TM2W
M&TYQ[*5_.U[_`'V?Y/6Z7K7CGP[8?$?P[+H?B#POJ=WI\DL4X$-XEM+'+%(L
MD4D<T5PLD;HZ*RNC!@0,&N0A^ O@FWT2]TN+P7KD27E_'JDUZFNRB_-XD8B6
MY6\%W]H68QC8TBR!F4L&)#'/G6C_`!5MO@QI7CCQ/:GQ1_PKB(:9::;_`,+'
MO-1LW_M:>9H929]5!N8;0*]H7D8,BD2F-68,IT]!_;"G\76.F6OAKP]H'BGQ
M'=^)#X;9=#\5)=Z0)#827J3I?);DO$$0*X,*NA$F$?:N]<M[V\OOT_X#]+,F
M[7X_=9M_A=/S31V-W\!/!%W8Z+:GP5KENNDI<1P36FN2V\\R7#K)<)<S1W:R
M72RNBO()VD$C#+9.:[CPEIEKX%\,Z9X>T+PM?:?HVFP+;6EHLT++#$HPJ M,
M3@#@9/2O%_%?[9-MX5L]+L+^R\+^'_%LTVH07EIXL\6II6FPO921QRK#>M Y
MF9S-&T:^4I*;B_EE=I]O^&GCVP^*/P_\/>+M+22+3]:LHKV&.4J70.H.TE25
M)'3*D@XR"1@T+WH\\=G^._W]=1/25GOK^&_H:']LW?\`T M0_P"^[?\`^.T?
MVS=_] +4/^^[?_X[6K12`RO[9N_^@%J'_?=O_P#':/[9N_\`H!:A_P!]V_\`
M\=K5HH RO[9N_P#H!:A_WW;_`/QVLSP_JUU'82A=%OI!]KNCE7@P"9Y"1S*.
M1T/TXR.:ZBLKPU_R#IO^OV[_`/2B2@#SG_A86E_\^NN?^""__P#C->7>(/A)
M\&_$?C+2/%,_P^6#7=/U-M6:\M_!4JRWDYCD7-PYM"TF&D\P'(/F(C9XKW:O
M!KSXE'4/CWJVDW7C;Q#X>TG1[NQTV+3]/T:.73;JYDC69EN[V2RD6$R?:((D
M03Q,3POS,*\Z',YI1W_K_@'0[\K['JG_``L+2_\`GUUS_P`$%_\`_&:U/A)X
MDM/^$,)\F_P^J:FX_P")=<9PU_<$9^3@X/(/(.00""*T:?\`"/\`Y$Z3_L+:
MK_Z<+BM*/Q$3V-[_`(26T_YXZA_X+KC_`.-T?\)+:?\`/'4/_!=<?_&ZU:*[
M3(RO^$EM/^>.H?\`@NN/_C='_"2VG_/'4/\`P77'_P`;K5HH`RO^$EM/^>.H
M?^"ZX_\`C='_``DMI_SQU#_P77'_`,;K5HH`RO\`A);3_GCJ'_@NN/\`XW1_
MPDMI_P`\=0_\%UQ_\;K5HH \7TKX/^&M*\=V_B%=6\63Z?9ZE<ZU8>&9;-AI
MEE?W".LUS&%MA,S-YTYVR2O&K3.50'!&_-H^C>);WPUJ=[_:R7/AW6[W4[1;
M:RE*/)(MU;XD_='(V7#G`((8#)X(/I-97AK_`)!TW_7[=_\`I1)33:22Z#;;
M;;ZW_&]_ON_FV^ISWCS3=%^(7AJ;1[_^V+53+#<V]Y9V$ZSVMQ#(LL,T9:)E
MW)(BL RLIQAE920?(O'WPIU/5[KX>P6_BGQSK%Q9>)I-7U'Q-<PHEY9*--NH
M8GBB%LEN%$C0KY20%6W,TB/N=C])T4)\NW];:^NBUWT78=]&NZ:^337Z^AX>
MOP8T2PL],ET;Q1XUT'Q+:/=O-XHM+".6_OOM3K)<B=9[.2 AY(XFPL*[/+58
M]BY4^FZ%?6&@:-8Z;$VM745I"D*SWUM=W$\@48W22.A9V/4L3DFNCHHO966W
M];=O0GS_`*^?=^;,K_A);3_GCJ'_`(+KC_XW1_PDMI_SQU#_`,%UQ_\`&ZU:
M*0&5_P`)+:?\\=0_\%UQ_P#&Z/\`A);3_GCJ'_@NN/\`XW6K10!E?\)+:?\`
M/'4/_!=<?_&ZS/#_`(@M8K"56BOB3=W3?+83L,&>0CD)UYY';H>:ZBLKPU_R
M#IO^OV[_`/2B2@#SG_A9W@[_`*&S0_\`P90__%5YKXM-CXQUYH-0^+/AFX\$
M27]IJ3Z-+%#]MBDMWCECCBNTN%58C+"CD/#(YW2*) "NSV^O$-0^,^LZA\9+
MOPOI&O>"M(MM/UH^OS.FIZTYABGNFM&64;!%%.F!Y,N]U8$QCYJ\Z'-S
MKEW_`."M?OL=#TBV>E?\+.\'?]#9H?\`X,H?_BJU/A)XKT0>#"W]L6&U]4U.
M13]J3#*U_<,K#GD$$$'N"*T:?\(_^1.D_P"PMJO_`*<+BM*/Q$3V-[_A+-$_
MZ#.G_P#@4G^-'_"6:)_T&=/_`/ I/\:U:*[3(RO^$LT3_H,Z?_X%)_C1_P`)
M9HG_`$&=/_\``I/\:U:*`,K_`(2S1/\`H,Z?_P"!2?XT?\)9HG_09T__`,"D
M_P`:U:* ,K_A+-$_Z#.G_P#@4G^-'_"6:)_T&=/_`/ I/\:U:\G\=?%CQ)X<
M^,GP_P#"=EX7/_".ZYJ$UG?^(;V5`A86-Q<)%;1J^\MF#YW=0@'RKO9B8VE=
MI(=M&^R;^[4]#_X2S1/^@SI__@4G^-9GA_Q-H\-A*LFK6,;&[NF :Y0'!GD(
M/7H00?QKR_P_\;_%&I^/=&N;BWTA? 6N^(]2\*6-O%!*-1AN;1;C%S),9#&T
M<CV5ROE")2H:)M[?,!['X:_Y!TW_`%^W?_I1)1;1/O\`U_7XZA).,G%[K]&U
M^::^0?\`"6:)_P!!G3__``*3_&C_`(2S1/\`H,Z?_P"!2?XUJT4A&5_PEFB?
M]!G3_P#P*3_&C_A+-$_Z#.G_`/@4G^-:M% &5_PEFB?]!G3_`/P*3_&C_A+-
M$_Z#.G_^!2?XUJT4`97_``EFB?\`09T__P`"D_QH_P"$LT3_`*#.G_\`@4G^
M-:M%`&5_PEFB?]!G3_\`P*3_`!K,\/\`B;1X;"59-6L8V-W=, UR@.#/(0>O
M0@@_C745E>&O^0=-_P!?MW_Z424`<]7@_C#X%:YJ/B?7X-)M] ;P]XHU[3M?
MU34[V1UU&SEM3;_NX(EA*S;A:IM=Y4,9D<X<``^I_P#"L?!W_0IZ'_X+8?\`
MXFO)/B-)<^!_%VB:;9_"'P'K.GZWJD.FZ>PU,PWT@*[YI6M_[.:-5B197;]\
M<J@P=S*M>;"_.N7?3\T_S2?R-Y?"[[?\!Z_=<^@*?\(_^1.D_P"PMJO_`*<+
MBN7_`.%8^#O^A3T/_P`%L/\`\36I\)/"FB'P85_L>PVIJFIQJ/LJ855O[A54
M<< ```=@!6M'XB9['H]%97_")Z)_T!M/_P# 5/\`"C_A$]$_Z VG_P#@*G^%
M=ID:M%97_")Z)_T!M/\`_ 5/\*/^$3T3_H#:?_X"I_A0!JT5E?\`")Z)_P!
M;3__``%3_"C_`(1/1/\`H#:?_P" J?X4`:M</\0/`]_XK\7?#G5;26WCM_#F
MM2ZE=K,S!WC:PN[8",!2"V^X0X) P&YS@'H_^$3T3_H#:?\`^ J?X5YGXN^(
MGAKPS\6O!O@.'P3)J%QKUU+;7&J_V;Y5C8;;2:Y0><T>R:5Q`1Y<9)499ROR
M!ZC?F26Y2O:7H[^EG?\``Q?#GP1\5Z;X_P!*MKN;1O\`A ="\2ZEXKT^YAN9
M6U*>XNUG_P!&EA,0C1(WO;IO,65BP6(;%^8U[-X:_P"0=-_U^W?_`*425Y;X
M2\677C7Q?<KI?PQTJ?P)#JEWHY\0_;H5NO.MBZ2R_8S"!Y'G1O"&68R$@-Y6
MT[AW_A_PSH\UA*TFDV,C"[NE!:V0G GD`'3H``/PI7?+'^G\_.UA3;<Y.6^O
MYMO\6W;I?L=1165_PB>B?] ;3_\`P%3_``H_X1/1/^@-I_\`X"I_A2$:M%97
M_")Z)_T!M/\`_ 5/\*/^$3T3_H#:?_X"I_A0!JT5E?\`")Z)_P! ;3__``%3
M_"C_`(1/1/\`H#:?_P" J?X4`:M%97_")Z)_T!M/_P# 5/\`"C_A$]$_Z VG
M_P#@*G^%`&K65X:_Y!TW_7[=_P#I1)1_PB>B?] ;3_\`P%3_``K,\/\`AG1Y
MK"5I-)L9&%W=*"ULA.!/( .G0 `?A0!1KA)_#.I:C\;[77;FV/\`8NE:"]M9
M3F12K75Q.#-A,[@5CMX?F(QB0@$_-C6_X5[I?_/UKG_@_O\`_P"/4?\`"O=+
M_P"?K7/_``?W_P#\>KS%=-2[7_%-?J=#U37>WX-/]+>ATM/^$?\`R)TG_86U
M7_TX7%<O_P`*]TO_`)^M<_\`!_?_`/QZM3X2>&[3_A#"/.O\)JFIH/\`B8W&
M<+?W`&?GY.!R3R3DDDDFMJ/Q$3V/1Z*RO^$:M/\`GMJ'_@QN/_CE'_"-6G_/
M;4/_``8W'_QRNTR-6BLK_A&K3_GMJ'_@QN/_`(Y1_P`(U:?\]M0_\&-Q_P#'
M* -6BLK_`(1JT_Y[:A_X,;C_`..4?\(U:?\`/;4/_!C<?_'*`-6O._B9X4U7
MQ#XX^%>H:?:_:+31-?GO;^3S$7R86TV]@#88@M^\FC7"Y/S9Q@$CK_\`A&K3
M_GMJ'_@QN/\`XY1_PC5I_P`]M0_\&-Q_\<IIV=QIV37=-?>K'S7X.^ 6I^$_
MBOH+6?@HVM[IWB/4]7O/B(MW`!>Z9<M=2KI^T2FY;]Y<1@PO&(%,1D5MVT'Z
M4\-?\@Z;_K]N_P#THDH_X1JT_P">VH?^#&X_^.5F>'_#]K+82LTM\"+NZ7Y;
M^=1@3R <!^O')[]3S26D5'^OZTV5EUM=L3UDY?UNW^O]6.HHK*_X1JT_Y[:A
M_P"#&X_^.4?\(U:?\]M0_P#!C<?_`!R@#5HK*_X1JT_Y[:A_X,;C_P".4?\`
M"-6G_/;4/_!C<?\`QR@#5HK*_P"$:M/^>VH?^#&X_P#CE'_"-6G_`#VU#_P8
MW'_QR@#5HK*_X1JT_P">VH?^#&X_^.4?\(U:?\]M0_\`!C<?_'* -6LKPU_R
M#IO^OV[_`/2B2C_A&K3_`)[:A_X,;C_XY69X?\/VLMA*S2WP(N[I?EOYU&!/
-(!P'Z\<GOU/-`'__V0``
`
end
Infinitogool replied on 11-Jul-08 12:58 PM
Hola Peter
contaba con que en b6 y b7 tendrias escrito los valores(7880,8559 o
Pacas y Pepes)si no es asi tienes que cambiar las formulas a:
en A6 puedes pones
=SUMAR.SI($B$1:$B$4;7880 u "otro valor";$A$1:$A$4)
en A7 puedes pones
=SUMAR.SI($B$1:$B$4;8559 u "otro valor";$A$1:$A$4)

como veras menos flexibles, tienes que cambiar los valores a mano

te recomiendo tener los valores en B6 hasta donde sea, y utilizar las
formulas anteriores

un saludo
Pedro J.
Peter replied on 11-Jul-08 01:12 PM
Ahora sí, funciona perfecto!!!
(A lo mejor para tí es una tontería pero a mí me has ayudado mucho.)
Muchas gracias y saludos
Peter
Infinitogool replied on 11-Jul-08 04:02 PM
Hola Peter
gracias a ti por contestar

Un saludo
Pedro J.
medio de la observación. Marilyn vos Savant"