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
https://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
![Kennjo - Lose My Mind (Official Hardstyle Audio) [Copyright Free Music]](https://images.videosashka.com/watch/SKWhRuQ00uQ)
