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"