sumproduct and if statement
I think what you are looking for is this:
=SUMPRODUCT(--($V$9:$V$90=$A$28),$AA$9:$AA$90,$AG$9:$AG$90)
"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
|