simplified formula

Copper Contributor

Okay so i kind of had this question before but i wasn't able to get it figured out properly so i did what i could with the formula


I have macros set up so i can count cells by color but i want to be able to count multiple colors in a given range. I've tried setting the formula up to pull from a range of colors (8 to be exact) ( (ex. =countcellsbycolor(a1:ab1,c1:c9) where c1:d1 would be a range of multiple colors. the formula won't work and just gives me #value.


right now i have the cell set up for the count cells by color to + to another count cells by color and it's for multiple cells and it's causing my excel sheet to be really slow.


is there a macro i can add or a simpler way to do my formula?

0 Replies