Adding multiple columns with similar criteria

**cellslinger** · 09-09-2011, 01:27 AM

All, I am pretty savvy with excel but for some reason I cannot figure this one out and I feel like I am missing something simple. Basically this is what i need..
Red Blue Green Red Blue Green
A A A B B B
Name 1 3 4 5 2 1 2
Name 2 2 5 3 3 2 1

I need to add all of the NAME1's that are red. Therefore the output would be
Red Blue Green
NAME1 5 5 7
NAME2 5 7 4

I have tried Vlookup, SUMIF, INDEX, but I cannot get it to work. PLEASE HELP. Thanks.

P.S. To put this into perspective, this is for a fashion company and the names are garment names, the Colors and A's and B's represent the garment sizes.

**romperstomper** · 09-09-2011, 01:46 AM

A sample workbook would make your data layout clearer I think.

**gjlindn** · 09-09-2011, 01:47 AM

Hi cellslinger. Could you upload a sample workbook? I know this can't be as simple as suming columns...but the way your data is shown above makes it appear that easy. An acutal example will ensure we understand your goal. Otherwise this matches your goal from above (assuming Red is in column B/E, Blue is in C/F and Green in D/G)
-------------Red--------------Blue--------------Green
Name1 =SUM(B3,E3) =SUM(C3,F3) =SUM(D3,G3)
Name2 =SUM(B4,E4) =SUM(C4,F4) =SUM(D4,G4)