If statement ... help needed.

[parsonsamie]

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

 

[JMB]

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))

 

[T. Valko]

Try this:

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

Biff

 

[parsonsamie]

Thank you both for your help .... so simple when you put it like that


Thanx
xx