SOLVED

Contar las veces que aparecen unos valores mayor o igual y menor o igual en una columna.

%3CLINGO-SUB%20id%3D%22lingo-sub-2165257%22%20slang%3D%22es-ES%22%3ECount%20the%20times%20that%20values%20greater%20than%20or%20equal%20to%20and%20less%20than%20or%20equal%20appear%20in%20a%20column.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2165257%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%2C%20first%20thank%20you%20very%20much%20for%20the%20attention%2C%20I%20hope%20you%20can%20help%20me.%3C%2FP%3E%3CP%3EI%20want%20to%20count%20the%20times%20%22greater%20than%20or%20equal%20to%20and%20less%20than%20or%20equal%22%20values%20of%20a%20column%20appear%20relative%20to%20values%20contained%20in%20a%20few%20cells.%20However%2C%20the%20value%20is%20zero%20%220%22.%3C%2FP%3E%3CP%3EAttached%20image.%3C%2FP%3E%3CP%3EThanks%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2165257%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hola, primero muchas gracias por la atención, espero puedan ayudarme.

Quiero contar los las veces que aparecen valores "mayor o igual y menor o igual" de una columna respecto a unos valores contenidos en unas celdas. Sin embargo el valor es cero "0".

Adjunto imagen.

Gracias de nuevo.

2 Replies
best response confirmed by Racor15 (New Contributor)
Solution

@Racor15 

You have to specify each condition separately:

 

=CONTAR.SI.CONJUNTO(K6:K4000; ">="&F2; K6:K4000; "<="&G2)

Muchísimas gracias. Rápido y eficaz. un crack @Hans Vogelaar