Sum Index Match

[bencaught]

Hello, I am looking for a way to sum the value of multiple columns for a matched value. Sheet1 Column A values are from a drop down list on Sheet2 Column A. Sheet1 If Column A = Red then add all the values in column B that match and the totals on B12-B17.

Excel 2010AB1Red12Orange23Yellow34Green45Blue56Purple67Red108Orange119Yellow1210Green131112Red13Orange14Yellow15Green16Blue17Purple[CENTER][COLOR=#161120][B]Sheet1[/B][/COLOR][/CENTER]

Excel 2010A1Red2Orange3Yellow4Green5Blue6Purple[CENTER][COLOR=#161120][B]Sheet2[/B][/COLOR][/CENTER]

 

[Marcelo Branco]

Welcome to Mr. Excel

II think what you want would certainly be possible, but try to better explain what you are trying to do. A small data sample along with expected/desired results would be helpful.

Anyway, maybe SUMIF can help - take a look at
http://www.contextures.com/xlFunctions01.html#SumIf

Hope this helps

M.