Dec 20 2016
- last edited on
Jul 25 2018
i have a column of numbers that are color coded (to represent a specific mfg department) and I need to total the values by color. Meaning I need to total all the values that have the same background color.
I have done an exhaustive search online and was able to quickly find a way to sum by color, unfortunately it only worked for cells whose color was set manually (NOT using conditional formatting). I have found a few references to VB code that should provide the functionality but I can't get any of them to run (except for the one that works for manually set colors).
I have control of the data that I'm trying to sum. is there another method to "tag" values? I thought of adding a letter prefix, but coulnd't find any way to sum a column of numbers that are contained in text strings.
Any help would be greatly appreciated!!
I'm using Office 365 (excel 2016) on a windows 10 machine
Aug 02 2021 03:56 AM
Nov 02 2021 07:05 AM
Hello Jamil I have looked at this and downloaded your spreadsheet but the formula in J2 and J3 doesn't count anything it just says #Value! am I missing something here because it doesnt seem to work at all. @Jamil Mohammad
Jan 06 2022 04:02 AM
@Jamil Mohammad I am also getting the No Color error and desperately need your help.
I have tried to troubleshoot but have not had any success.
How can I attach the file for you to view? It keeps telling me "file type is not supported"
Feb 02 2022 06:48 AM
Mar 22 2022 09:29 AM
Good day, i've been trying to adapt my document to all the ones you already shared to count the number of cells colored by a conditional formatting but no succeed.
On my file i'd like to count the number of cells in red, yellow and green.
Could you help me with it?
if you allow me i could send it directly to you by message as i cant upload any document into this message.