Assuming "Required" will only be either a 1 or a 0:
=SUMPRODUCT(A2:A35, B2:B35, C2:C35)

otherwise
=SUMPRODUCT(A2:A35, B2:B35, --(C2:C35=1))


"parsonsamie" wrote:


Hi,

I have a spreadsheet that looks like this;

Rate Weeks Required
150 4.33 1
120 4.33 0

And this continues on for 34 lines.

I need to be able to get one total.

If the value in "Required" = 1 then Rate * Weeks .... adding a
culmative total for all 34 rows.

Does anyone know of a single formula that can accomplish this or code
for it.

Thanx




--
parsonsamie