How to count row by row based on color in excel

[jack.chan]

@Raja.G please try out this sequence
Sequence.xaml (24.2 KB)
sample

set name here

result (result is a dictionary of the colors + # occurences)