I’m trying to create a spreadsheet for counting various items of same type.
I have two columns. One is color, the other is count. I may have many rows containing the same value for color (e.g. Blue), I also have a count column, which shows how many items that I have for the same row (e.g. 3). So while counting instead of adding 1 for each row, I want to add count amount to the total sum for that color.
e.g. If a row contains Blue as color and 3 as count, I want to add 3 to the total number of blues.
