If/V-Hlookup/Index match

[Funmilicious]

I want to reference one spreadsheet's data on another sheet. In the first sheet containing all the data, I have months in ROW 1 January-December. In rows 4-8, I have values according to different variables. It looks somewhat like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Mar[/TD]
[TD]Mar[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]1/7[/TD]
[TD]1/28[/TD]
[TD]3/5[/TD]
[TD]3/6[/TD]
[TD]3/15[/TD]
[TD]4/1[/TD]
[TD]5/19[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Mark[/TD]
[TD]Ben[/TD]
[TD]Jerry[/TD]
[TD]Luke[/TD]
[TD]Mary[/TD]
[TD]Judy[/TD]
[TD]Lauren[/TD]
[/TR]
[TR]
[TD]Bag Sale[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hat Sale[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Shoe Sale[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Glove Sale[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shirt Sale[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

On another sheet, I would like the total SUM by month. So Jan=2, Feb=0, Mar=3 etc. I have tried using SUM IF =SUMIF($A$1:$H$1,"Jan",$B$4:$H$8),SUMIF($A$1:$H$1,"Feb",$B$4:$H$8) etc but that is not working. I tried HLOOKUP since there are multiple instances of a single month, but no luck.

Can someone help me?

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=SUM(IF($B$1:$H$1="Jan",$B$4:$H$8))

 

[Funmilicious]

Control+shift+enter, not just enter:

=SUM(IF($B$1:$H$1="Jan",$B$4:$H$8))

Thank you! It worked!

 

[Aladin Akyurek]

Thank you! It worked!

You are welcome.