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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies