Count or Sum of values on the basis of font color

[Akshay_Pathak]

Hi Team,

How to make calculation such as Count or sum of values on the basis of font color ?

[#2]

@Akshay_Pathak 

If the font color has been applied directly, it requires VBA code. See for example How to sum and count cells by color in Excel 

If the font color is the result of conditional formatting, you can use SUMIFS/COUNTIFS with the same conditions as the conditional formatting rule.