Create column totals by period

[nickwetherall]

sum test.xls
	B	C	D	E	F	G	H
4			1	1	1	1	2
5	details	Period	Week1	Week2	Week3	Week4	Week5
6			07/01/2007	14/01/2007	21/01/2007	28/01/2007	04/02/2007
7	Rent	two	50	57	57	57	57
8	Commission	one	60	43	43	43	43
9
10	Rent	two	45	5	5	5	5
11	Commission	one	55	43	43	43	43
Sheet1

Please can somebody help me with what is more than likely a simple problem.

On the above table I would like to be able to create a formula that will add together the figures for all columns with a 1 and all rows with Rent as a detail giving a total of 281.

I have tried sumif and sumproduct formula's, but they only add together the first column. Is there a way of extending these to cover the other columns.

Thank you in advance for you help.

 

[Boller]

{=SUM(IF((A4:A100="Rent")*(C1:IV1=1),(C4:M100)))}

 

[stanleydgromjr]

nickwetherall,

This works:
=SUMPRODUCT(($B$4:$B$8="Rent")*($D$4:$H$8)*($D$1:$H$1=1))

Have a great day,
Stan