Previous Topic Next Topic

Calculate based on the color of the cell

Closed
50butNifty - 5 Oct 2010 à 10:42
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 6 Oct 2010 à 05:56
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
Related:

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
6 Oct 2010 à 05:56
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Name Values
brendanconlin -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response