Forum Discussion
Hamburg123
Jan 28, 2019Copper Contributor
Sum up formula for colour marked cells
Is there a formula in Excel that automatically sums up the number of color-coded cells (such as red)?
2 Replies
- SergeiBaklanDiamond Contributor
I guess similar discussion is here https://techcommunity.microsoft.com/t5/Excel/How-to-count-and-sum-quot-Condtional-formatting-quot-cells-by/m-p/116110#M2426
- Eva VogelIron ContributorHello! Check this out pls. https://www.ablebits.com/office-addins-blog/2013/12/12/count-sum-by-color-excel/
Greets, Eva