Apr 08 2019 08:14 AM - edited Apr 08 2019 08:30 AM
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
Apr 08 2019 02:15 PM
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.