Forum Discussion

Jessssssssss's avatar
Jessssssssss
Copper Contributor
Apr 09, 2024

simplified formula

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?

No RepliesBe the first to reply

Resources