Originally Posted by T. Valko

Try this:

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

Biff

"parsonsamie" wrote in message
...

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