The purpose is to find out how many reds I have of a minute (minus greens becuase green means its not red anymore. )

So what I did was a another column with this value: =J7+G8+H8

J is the column with the total for red values, G has a 1 if red, H has a -1 if green.

K, follow that? So now I'm looking for a sum per minute, or the highest value in J for the times that match to the minute.

K, total newb to this, dunno if I need a macro or not, or what.

Please help, and if you could in a way that will teach so Im not just getting someone to do my work