Heh there.. (I am using Excel 2007)
I have problem and that is i want to get the color of cell and then sum them with the sumifs function
E.g i have two columns one based on the different products and other on the figures.
Products Figure
1- A 5
2- B 10
3- A 5 (in red color or any color)
4- B 10
5- C 5
6- D 10
7-A 10 (in red color or any color)

now i want to sum the product A where figure color is red so please help me to apply the formula