Formulas:

=SUMAR.SI(Tabla!C4:C20;"Deportivo";Tabla!D4:D20)

=SUMAR.SI(Tabla!C4:C20;"Deportivo";Tabla!E4:E20)

Formulas:

=CONTAR.SI(Tabla!A4:A20;"Ana")

=SUMAR.SI(Tabla!A4:A20;"Ana";Tabla!E4:E20)

=SUMA(B2:D2)

Formulas:

=SI(C4="Sandalia";(E4*D4)*10%;(E4*D4)*5%)

=(D4*E4-F4)*21%

=D4*E4-F4+G4

=SUMAR.SI(A4:A20;"Ana";I4:I20)

=SI(N7>10;Vendedores!B3*10%;0)