Is it possible to compile data from several rows?
Thanks to Domenic, my spreadsheet is coming along nicely, and now I would like to see if its possible to condense several listings for the same item into a single amount.
The table is set up with paired columns. A is "Name", B is "Amount of A", and so on.
So if I had three rows, and comma's indicate seperate columns...
___A , B , C , D , E , F , G , H
1 - Green, 10, White, 5, Black, 20, Yellow, 5,
2 - Black, 5, Red, 100, Yellow, 5, White, 2,
3 - Yellow, 50, White, 30, Red, 100, Yellow, 5,
Manually, combining the data would equal:
Green = 10 (1 green entry)
White = 37 (3 white entries)
Black = 25 (2 black entries)
Red = 200 (2 red entries)
Yellow = 65 (4 yellow entries)
So, is there a function I could use to combine the scattered unique color amounts into a single value?
Bookmarks