| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct and if statement
this worked perfectly - thanks!
"Toppers" wrote: did you try the formula? .... because that's this does ... =SUMPRODUCT(--($V9:$V90=A28),$AA$9:$AA$90,AG9:AG90) "ellebelle" wrote: sorry i should have explained better. if cell A28 equals a cell in col. V then mulitply the corresponding cell in col. AA by the corresponding cell in col AG. does that make sense? the reason that shot type appears in the list more than once is that each type of shot appears in different sections of a very big job. ellebelle "Toppers" wrote: Try: =SUMPRODUCT(--($V9:$V90=A28),$AA$9:$AA$90,AG9:AG90) "ellebelle" wrote: I have the following formula that is not working as I would like it to. =IF($V9:$V90=A28,SUMPRODUCT($AA$9:$AA$90,AG9:AG90) ) I have three columns of data: col. V has type of shot (shot1, shot 2, shot 3 etc.) col. AA has number of shots per type (4, 5,2 etc) col. AG has number of days each type of shot should take to finish (3, 5, 19 etc) I would like to enter the shot type name into cell A28 and retireve hte total number of days that the shot type requires. Pls note that a shot type can appear in the col V more than once. any ideas? e |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT problem, using OR within statement | Excel Worksheet Functions | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Multiple if criteria in one statement (if/sumproduct) | Excel Discussion (Misc queries) | |||
| sumproduct formula too long, & how to use make an 'OR' statement w | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
Threaded Mode
