hat
Gen anpil fòmil pou fè kalkil done nan Excel. Men, si ou vle konte oswa selil sòm pa ranpli yo oswa koulè background oswa koulè font, ak fè kalkil lòt ak yon seri de selil ki baze sou yon background espesifye, font, koulè kondisyonèl fòma, pa gen okenn fòmil sa yo pou ou pou w fè Se konsa, nan Excel. Men Kutools pou Excel's Konte pa Koulè sèvis piblik ka byen vit aplike kalkil nan selil ki baze sou koulè selil ak jenere yon rapò nan yon nouvo liv.
eng
There are many formulas to perform data calculation in Excel. But if you want to count or sum cells by their fill or /background color or font color, and do other calculations with a range of cells based on a specified background， font, conditional formatting color, there is no such formula for you to do so in Excel. But Kutools for Excel's Count by Color utility can quickly apply calculations to cells based on cell color and generate a report in a new workbook.