Home

Sum up formula for colour marked cells

%3CLINGO-SUB%20id%3D%22lingo-sub-326391%22%20slang%3D%22en-US%22%3ESum%20up%20formula%20for%20colour%20marked%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326391%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20formula%20in%20Excel%20that%20automatically%20sums%20up%20the%20number%20of%20color-coded%20cells%20(such%20as%20red)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-326391%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecoloured%20cells%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326445%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20up%20formula%20for%20colour%20marked%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326445%22%20slang%3D%22en-US%22%3E%3CP%3EI%20guess%20similar%20discussion%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FHow-to-count-and-sum-quot-Condtional-formatting-quot-cells-by%2Fm-p%2F116110%23M2426%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FHow-to-count-and-sum-quot-Condtional-formatting-quot-cells-by%2Fm-p%2F116110%23M2426%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326429%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20up%20formula%20for%20colour%20marked%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326429%22%20slang%3D%22en-US%22%3EHello!%20Check%20this%20out%20pls.%20%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2013%2F12%2F12%2Fcount-sum-by-color-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2013%2F12%2F12%2Fcount-sum-by-color-excel%2F%3C%2FA%3E%3CBR%20%2F%3EGreets%2C%20Eva%3C%2FLINGO-BODY%3E
Hamburg123
Occasional Visitor

Is there a formula in Excel that automatically sums up the number of color-coded cells (such as red)?

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