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:

Month	Jan	Jan	Mar	Mar	Mar	Apr	May
Date	1/7	1/28	3/5	3/6	3/15	4/1	5/19
Name	Mark	Ben	Jerry	Luke	Mary	Judy	Lauren
Bag Sale	1				1
Hat Sale		1					1
Shoe Sale				1
Glove Sale						1
Shirt Sale			1

<tbody>
</tbody>

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.