| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a formula in Excel | Excel Worksheet Functions | |||
| Create a formula that determines a date-sensitive File-Name from w | Excel Worksheet Functions | |||
| How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
| How do I create a formula that will multiply a 5% of a value >$150 | Excel Worksheet Functions | |||
| Please help create a formula | Excel Worksheet Functions | |||
Threaded Mode
