Dear All,
I have a example data like below;
TABLE
S.NO. COLOR ITEM VALUE
1 NAVY 123 400
2 BLUE 321 512
3 MAROON 122 610
4 NAVY 123 510
5 WHITE 321 408
6 BLACK 122 512
7 NAVY 122 403
8 WHITE 123 506
9 BLACK 122 408
10 MAROON 213 612
11 WHITE 123 616
12 NAVY 123 502
13 BLACK 321 499
14 NAVY 122 388
15 WHITE 231 477
16 MAROON 122 584
I need help to get a formula which compile the data as below;
COLOR ITEM SUM VALUE
BLACK 122 920
BLACK 321 499
BLUE 321 512
MAROON 122 1,194
MAROON 213 612
NAVY 122 791
NAVY 123 1,412
WHITE 123 1,122
WHITE 231 477
WHITE 321 408
File is attached and looking forward for help, this formula will pick all detail by itself so its not a "SUMIF" where we need to enter the color and item.
in table the color and item list may add on and all new names can be added so the same should summarized with help of formula like what pivot table do.
I have a example data like below;
TABLE
S.NO. COLOR ITEM VALUE
1 NAVY 123 400
2 BLUE 321 512
3 MAROON 122 610
4 NAVY 123 510
5 WHITE 321 408
6 BLACK 122 512
7 NAVY 122 403
8 WHITE 123 506
9 BLACK 122 408
10 MAROON 213 612
11 WHITE 123 616
12 NAVY 123 502
13 BLACK 321 499
14 NAVY 122 388
15 WHITE 231 477
16 MAROON 122 584
I need help to get a formula which compile the data as below;
COLOR ITEM SUM VALUE
BLACK 122 920
BLACK 321 499
BLUE 321 512
MAROON 122 1,194
MAROON 213 612
NAVY 122 791
NAVY 123 1,412
WHITE 123 1,122
WHITE 231 477
WHITE 321 408
File is attached and looking forward for help, this formula will pick all detail by itself so its not a "SUMIF" where we need to enter the color and item.
in table the color and item list may add on and all new names can be added so the same should summarized with help of formula like what pivot table do.