Traducir una función

[Tinacho]

Yo tenía el tradyctor de funciones. y les juro que no soy un bruto para usar las computadoras. de hecho hasta soy hábil... pero el traductor de funciones no sé si lo bajé mal o que, pero nunca lo pude usar. y necesito saber como traducir ésto para un excel 2003 proffesional edition en Español

B2 for games played:
=COUNTIF(Sheet2!B$2:B$8,A2)+COUNTIF(Sheet2!E$2:E$8,A2)

C2 for games won:
=SUMPRODUCT(--(Sheet2!B$2:B$8=$A2),--(Sheet2!C$2:C$8>Sheet2!F$2:F$8))+SUMPRODUCT(--(Sheet2!E$2:E$8=$A2),--(Sheet2!C$2:C$8 similar for lost and draws, just select which one is greater or equal...

you can calculate points

for G2:
=SUMPRODUCT(--(Sheet2!B$2:B$8=$A2),--(Sheet2!C$2:C$8>Sheet2!F$2:F$8),--(Sheet2!C$2:C$8))+SUMPRODUCT(--(Sheet2!E$2:E$8=$A2),--(Sheet2!C$2:C$8

Solo el sumproduct que no sé cual es.

 

[Tinacho]

Nadie?

 

[galileogali]

=COUNTIF(Sheet2!B$2:B$8,A2)+COUNTIF(Sheet2!E$2:E$8,A2)

CONTAR.SI(HOJA2!..................

=SUMPRODUCT(--(Sheet2!B$2:B$8=$A2),--(Sheet2!C$2:C$8>Sheet2!F$2:F$8))+SUMPRODUCT(--(Sheet2!E$2:E$8=$A2),--(Sheet2!C$2:C$8

=sumaproducto(--(Hoja2!..............................