Home

quiero almacenar los resultados de la formula contar si cuando recalculo con F9 en celdas diferentes

%3CLINGO-SUB%20id%3D%22lingo-sub-1294386%22%20slang%3D%22es-ES%22%3EI%20want%20to%20store%20the%20results%20of%20the%20formula%20counting%20if%20when%20I%20recalculate%20with%20F9%20in%20different%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1294386%22%20slang%3D%22es-ES%22%3E%3CP%3EIn%20sheet%205%20and%20column%20AY%20there%20are%2010000%20values%20of%201%20and%200%20I%20want%20to%20count(cell%20BA2)%20the%201%20and%20divide%20them%20by%2010000%20as%20this%20gives%20me%20a%20probability.%20I%20want%20to%20repeat%20the%20operation%20with%20F9%20about%2010%20times%20and%20save%20each%20result.%20Like%20I%20do%3F%3F%3F.%20Or%20maybe%20there's%20a%20better%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1294386%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1294817%22%20slang%3D%22en-US%22%3ERe%3A%20quiero%20almacenar%20los%20resultados%20de%20la%20formula%20contar%20si%20cuando%20recalculo%20con%20F9%20en%20celdas%20difere%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1294817%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F615126%22%20target%3D%22_blank%22%3E%40manu_agus605%3C%2FA%3EHola%20Manu%2C%20podrias%20reformular%20la%20pregunta%3F%3C%2FP%3E%3CP%3ENo%20logro%20entenderte.%20Muchas%20gracias%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

En la hoja 5 y la columna AY hay 10000 valores de 1 y 0 deseo contar(celda BA2) los 1 y dividirlos por 10000 ya que esto me da una probabilidad. Quiero repetir la operación con F9 unas 10 veces y guardar cada resultado. Como hago???. O quizas hay mejor manera.

1 Reply
Highlighted

@manu_agus605Hola Manu, podrias reformular la pregunta?

No logro entenderte. Muchas gracias