Home

Cinta simplificada de Office - Encuesta en español

%3CLINGO-SUB%20id%3D%22lingo-sub-407933%22%20slang%3D%22es-ES%22%3ESimplified%20Office%20Tape-Survey%20in%20Spanish%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-407933%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%20I%20need%20to%20make%20the%20formula%20to%20add%20conditioned%20amounts%20to%20cells%20of%20the%20same%20color.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-407933%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-411875%22%20slang%3D%22en-US%22%3ERe%3A%20Cinta%20simplificada%20de%20Office%20-%20Encuesta%20en%20espa%C3%B1ol%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-411875%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F316056%22%20target%3D%22_blank%22%3E%40MANDUJASDEREYNOSA%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EColor%20is%20not%20data.%20Excel%20does%20not%20have%20a%20function%20for%20that.%20What%20is%20the%20logic%20for%20the%20cells%20to%20have%20a%20specific%20color%3F%20If%20you%20use%20conditional%20formatting%20to%20set%20the%20color%20of%20cells%2C%20you%20need%20to%20apply%20logic%20rules.%20You%20can%20use%20the%20same%20logic%20rules%20for%20calculations.%20But%20if%20you%20manually%20format%20a%20cell%20to%20a%20specific%20color%20that%20cannot%20be%20used%20in%20a%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E
MANDUJASDEREYNOSA
Occasional Visitor

Hola necesito hacer la formula para sumar cantidades condicionados a celdas de un mismo color.

 

Hello, I need to make the formula to add quantities conditioned to cells of the same color. Help

1 Reply

Hello @MANDUJASDEREYNOSA 

 

Color is not data. Excel does not have a function for that. What is the logic for the cells to have a specific color? If you use conditional formatting to set the color of cells, you need to apply logic rules. You can use the same logic rules for calculations. But if you manually format a cell to a specific color that cannot be used in a formula.