Rango a celdas seleccionables

%3CLINGO-SUB%20id%3D%22lingo-sub-1527938%22%20slang%3D%22es-ES%22%3ERange%20to%20selectable%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527938%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20afternoon%2C%20from%20the%20following%20image%20I%20would%20like%20to%20know%20how%20to%20set%20the%20respective%20values%20to%20each%20cell%2C%20but%20without%20these%20being%20seen%20and%20you%20can%20select%20an%20option%20for%20each%20row%20and%20to%20be%20able%20to%20make%20a%20sum%20only%20of%20the%20selected%20cells.%20Thanks%20a%20lot%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WhatsApp%20Image%202020-07-16%20at%2017.51.51.jpeg%22%20style%3D%22width%3A%20257px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205941iE2B2A18C3A52B7FD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WhatsApp%20Image%202020-07-16%20at%2017.51.51.jpeg%22%20alt%3D%22WhatsApp%20Image%202020-07-16%20at%2017.51.51.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1527938%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1534853%22%20slang%3D%22en-US%22%3ERe%3A%20Rango%20a%20celdas%20seleccionables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1534853%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F731308%22%20target%3D%22_blank%22%3E%40jdah1995%3C%2FA%3E%26nbsp%3BNot%20entirely%20sure%20if%20your%20values%20in%20the%20columns%20are%20always%20from%201%20to%205%20as%20indicated%20in%20the%20picture%2C%20you%20can%20use%20the%20solution%20as%20in%20column%20H%20in%20the%20attached%20workbook.%20A%20simple%20MATCH%20function%20to%20determine%20which%20option%20was%20selected%20for%20each%20row%2C%20returning%20a%20value%20from%201%20to%205.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20if%20the%20values%20for%20each%20column%20and%20row%20are%20NOT%20always%201%20to%205%2C%20then%20you%20need%20to%20include%20a%20table%20(can%20be%20located%20on%20another%20sheet%20or%20hidden)%20where%20you%20can%20set%20the%20value%20for%20each%20cell%20and%20then%20combine%20the%20MATCH%20function%20with%20INDEX%20to%20find%20the%20correct%20value%20for%20the%20selection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnything%20more%20sophisticated%20will%2C%20most%20likely%2C%20require%20VBA%20programming%2C%20which%20as%20I%20understand%20is%20not%20an%20option%20for%20the%20web%20version%20of%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Buenas tardes, de las siguiente imagen me gustaría saber como establecer los respectivos valores a cada celda, pero sin que estas se vean y se pueda seleccionar una opción por  cada fila y para poder realizar un suma solo de las celdas seleccionadas. Muchas gracias

WhatsApp Image 2020-07-16 at 17.51.51.jpeg

 

1 Reply

@jdah1995 Not entirely sure if your values in the columns are always from 1 to 5 as indicated in the picture, you can use the solution as in column H in the attached workbook. A simple MATCH function to determine which option was selected for each row, returning a value from 1 to 5.

 

Now, if the values for each column and row are NOT always 1 to 5, then you need to include a table (can be located on another sheet or hidden) where you can set the value for each cell and then combine the MATCH function with INDEX to find the correct value for the selection.

 

Anything more sophisticated will, most likely, require VBA programming, which as I understand is not an option for the web version of Excel.