Hello all, my first post on the forum!
I have a long list of data in an annoying format a bit like the following:
Column A
Red
5
Blue
2
Blue
4
Green
1
Red
3
I would like to sum all the values for a certain colour, i.e. sum every number that comes directly under the word "blue"
Have looked all over for a solution, would massively appreciate any help on this
Thanks in advance
Bookmarks