How to sum values based on cell color in excel | 3 methods

00:17 - Method 1: filter
02:19 - Method 2: GET.CELL
07:33 - Method 3: VBA
www.mrexcel.com/board/threads...
=LAMBDA(cell,GET.CELL(63,cell)+(NOW()*0))
Function SumByColor(rng, mycolor)
Application.Volatile
For Each cell In rng
If cell.Interior.Color = mycolor.Interior.Color Then
Total = Total + cell.Value
End If
Next cell
SumByColor = Total
End Function

[@vadimkondratiev7214]

fourth (and best) method. train the team so that they never use colors in a table but rather add a column to put the necessary info