Previous Topic Next Topic

Calculate based on the color of the cell

Closed
50butNifty - Oct 5, 2010 at 10:42 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 6, 2010 at 05:56 AM
Hello,



I am trying to write an if formula in Excel 2007 that will calculate the sum of all the cells that are a certain color. Can you help me do this? For instance if the cell is green then I want to add all the green cells, yellow? add the yellow cells, red? add the red cells.

Can this be done?

Thank you!

Pam

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 6, 2010 at 05:56 AM
you need a macro
see this webpage

http://www.cpearson.com/excel/colors.aspx

see this section

Function SumColor(TestRange As Range, SumRange As Range, _
ColorIndex As Long, Optional OfText As Boolean = False) As Variant
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response