counting colored cells

[ttowncorp]

is there a simple way to add up colored cells on your sheet by rows or columns. how many yellows do I have in this row or column etc.

 

[Domenic]

Have a look at the following link...

http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

Hope this helps!

 

[Fluff]

If your cells are manually coloured have a look here https://www.ablebits.com/office-addins-blog/2013/12/12/count-sum-by-color-excel/

 

[Special-K99]

If they are set by conditional formatting just use the same set of conditions to count them otherwise its a VBA job.