Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
|
|||
|
|||
Thank you both for your help .... so simple when you put it like that. :-)
Thanx xx Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with IF statement needed | Excel Worksheet Functions | |||
IF STATEMENT HELP NEEDED!!! | Excel Discussion (Misc queries) | |||
help needed with "if" statement | Excel Worksheet Functions | |||
much needed If/or statement help | Excel Discussion (Misc queries) | |||
If statement needed | Excel Worksheet Functions |