Thread: Create formula
View Single Post
  #1   Report Post  
Leo
 
Posts: n/a
Default Create formula

Formula :
=IF(B3=0,0,INDEX(data1,B3+1,MATCH($B$2,data2,0)))+ IF(C3=0,0,INDEX(data1,C3+1,MATCH($C$2,data2,0)))+
.......+IF(N3=0,0,INDEX(data1,N3+1,MATCH($N$2,data 2,0)))
where data1 and data2 areas from aux table.

Works fine ... , but very long ..

Does it possible to create shorter formula ( may be array) without
"+"'s
and based on range B3:N3 ?

Thanks for help