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