If statement ... help needed.
 

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

If statement ... help needed.
 

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

If statement ... help needed.
 

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

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

Thanx
xx