summing, aggregation

[shan2207]

hi everbody,

have following problem:

i want to sum a column when special conditions are fulfilled.
i used the sumif function, but it didnt work if i have different conditions in different columns.
i used the array function, it should function, but it didn't..
i want to sum up the column "hours" only in rows where Id=50 and phase=Impl.
Id and phase are the name of other columns.

=SUM((TASKS!K5:K9="IMPL")*(TASKS!I5:I9=50)*TASKS!N5:N9)
TASKS ist just another sheet. and K is phase and I is Id and N is hours.

maybe someone can help me.
thanks, regards,
shan

[scottylad2]

==SUM((TASKS!K5:K9="IMPL")*(TASKS!I5:I9=50)*TASKS!N5:N9)
Try using =Sumproducts(--(TASKS!K5:K9="IMPL"),--((TASKS!I5:I9=50),TASKS!N5:N9)