Zapateria:

=CONTAR.SI(Hoja1!C4:C20;"zapato")
=SUMAR.SI(Hoja1!C4:C20;"zapato";Hoja1!H4:H20)
=SUMA(B2:B4)
=SUMA(C2:C4)