vendedores

=CONTAR.SI(Hoja1!A4:A20;"ana")
=SUMAR.SI(Hoja1!A5:A21;"jose";Hoja1!H5:H21)
=SUMAR.SI(Hoja1!A6:A22;"pedro";Hoja1!I6:I22)
=SI(D4>10;(C4*5%);0)
=+SUMA(B2:B4)