Is there a formula that will count the arrows by colour ... Just looking at your data in column label P, it looks like the green up arrows match with 1,2,3; the brown right arrows match with 4,5,6,7; and the red down arrows match with 8,9,#. Is that the case? If that's how the arrows work, then you could add a column next to P (or even way off to the right so it doesn't show) and populate it with the ...