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.