Adding time worked in excel

[bucci35]

Hello,
Considering the cells below are in the following order of color. (green, green, red, red, yellow) I need to be able to sum the colors separately. Any ideas? TIA!
A B C D E

5

4

1

3

8

 

[Cubist]

You'd need VBA. Is that what you're looking?
Is there a rule for determining the color?

 

[bucci35]

yes if that works. No rule for determining the color

 

[Cubist]

Using hex code is the most reliable instead "green", "red", ect...
The VBA function takes in a range, and a hex string (indicate which color).

Function SumByHexColor(CellRange As Range, hexColor As String) As Double
    Dim cell As Range
    Dim totalSum As Double
    Dim colorValue As Long
    
        
    Application.Volatile
    If Left(hexColor, 1) = "#" Then hexColor = Mid(hexColor, 2)
    colorValue = CLng("&H" & Right(hexColor, 6))
    
    For Each cell In CellRange
        If cell.Interior.Color = colorValue Then
            If IsNumeric(cell.Value) Then
                totalSum = totalSum + cell.Value
            End If
        End If
    Next cell

    SumByHexColor = totalSum

End Function

Usage:

Book1
	A	B	C	D	E
1	5	4	1	3	8
2
3	Color	Hex#	Sum
4	Green	#00FA00	9
5	Red	#0026FF	4
6	Yellow	#00FFFF	8
Sheet1

Cell Formulas
Range	Formula
C4:C6	C4	=SumByHexColor($A$1:$E$1,B4)