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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies