Home

Excel Question

%3CLINGO-SUB%20id%3D%22lingo-sub-834941%22%20slang%3D%22en-US%22%3EExcel%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834941%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20away%20to%20sum%20the%20contents%20of%20a%20number%20of%20cells%20of%20a%20certain%20color%3F%26nbsp%3B%20%26nbsp%3BExample-I%20am%20looking%20for%20the%20sum%20of%20all%20the%20Yellow%20cells%20and%20the%20Red%20cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-834941%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835043%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835043%22%20slang%3D%22en-US%22%3EAs%20I%20know%20there%20is%20no%20formula%20to%20get%20cell%20color.%20However%20you%20can%20hide%20the%20cells%20without%20the%20desirec%20cell%20color%20and%20use%20Aggregate%20function%20to%20get%20the%20sum.%20If%20cell%20color%20is%20defined%20by%20conditional%20formatting%20then%20you%20can%20use%20the%20same%20formula%20in%20a%20helper%20column%20and%20use%20sumif.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835811%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835811%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402768%22%20target%3D%22_blank%22%3E%40rick52%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20these%20colors%20are%20set%20by%20conditional%20formatting%2C%20check%20out%20this%20link%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fsum-by-color-when-colors-are-set-by-conditional-formatting%2Fm-p%2F36495%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fsum-by-color-when-colors-are-set-by-conditional-formatting%2Fm-p%2F36495%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20they%20are%20set%20by%20normal%20background%20color%2C%20check%20out%20this%20link%20instead%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F1155-excel-count-sum-cells-by-color.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F1155-excel-count-sum-cells-by-color.html%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E
rick52
Occasional Visitor

Is there away to sum the contents of a number of cells of a certain color?   Example-I am looking for the sum of all the Yellow cells and the Red cells.

2 Replies
As I know there is no formula to get cell color. However you can hide the cells without the desirec cell color and use Aggregate function to get the sum. If cell color is defined by conditional formatting then you can use the same formula in a helper column and use sumif.

@rick52

 

Hi,

 

If these colors are set by conditional formatting, check out this link:

https://techcommunity.microsoft.com/t5/Excel/sum-by-color-when-colors-are-set-by-conditional-formatt...

 

If they are set by normal background color, check out this link instead:

https://www.extendoffice.com/documents/excel/1155-excel-count-sum-cells-by-color.html

 

Hope that helps

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies