Summation of Cells Which Filled With Some Desired Color

[Galav Dani]

Hello Everyone..

Imagine there is a range which having different numbers in each cells and also filled with different colours.
I want to summation of all different colours cells as summary.

also I want to count also each cells having different colours.

eg. I want to sum all cell details which are filled with yellow colour also I want to count also that many cells which are filled with yellow colour from the specified range.
Please suggest me.

 

[bobhc]

Excel has no built in functions to use cell colours as conditions in formulas. Scroll down a small way in this link

http://www.extendoffice.com/documents/excel/1155-excel-count-sum-cells-by-color.html

Or this link

http://www.ablebits.com/office-addins-blog/2013/12/12/count-sort-by-color-excel/#


.