SUMIF to check color of cell

Do a search on 'SUMIF Color'. Looks like that provides some interesting results.

Check out the options on this page: http://www.cpearson.com/excel/colors.htm

There is a specific part titled "Summing The Values Of Cells With A Specific Color" which is probably what you're looking for.

Hope it helps,

What determines if cells are red or yellow -- are there set criteria? The reason I ask is that cell color is not distinguishable outside a VBA solution.

thankz very much guys

where this function should be put in order to call it from the worksheet?

Function SumIfByColor(InRange As Range, WhatColorIndex As
Integer, SumRange As Range, Optional OfText As _
Boolean = False) As Variant
'
' This function will return the SUM of the values of cells in
' SumRange where the corresponding cell in InRange has a background
' color (or font color, if OfText is true) equal to WhatColorIndex.
'
Dim OK As Boolean
Dim Ndx As Long

Application.Volatile True

If (InRange.Rows.Count <> SumRange.Rows.Count) Or _
(InRange.Columns.Count <> SumRange.Columns.Count) Then
SumIfByColor = CVErr(xlErrRef)
Exit Function
End If

For Ndx = 1 To InRange.Cells.Count
If OfText = True Then
OK = (InRange.Cells(Ndx).Font.ColorIndex = WhatColorIndex)
Else
OK = (InRange.Cells(Ndx).Interior.ColorIndex = WhatColorIndex)
End If
If OK And IsNumeric(SumRange.Cells(Ndx).Value) Then
SumIfByColor = SumIfByColor + SumRange.Cells(Ndx).Value
End If
Next Ndx

End Function

There is an add-in for Excel 2007, 2010, and 2013 called xCELLcolor that provides sum by background color, count by background color, sum by font color, and count by font color formulas without having to use VBA/macros.