Spreadsheet: 94701d1294431298-sumifs-index-match-code-problems-excelforumhelpfile11v4
Sheet: Sheet1

Assumption: | 3
Title 1
Location
Type
Options |  | D
Date 1
Time (months)
Number
[NAME].
Date 2
Payoff
Price
Interest
Date 3
Period (months)
Payment
Date 4
Period (months)
Interest
Price
Amount
 |  |  |  | 1 | 2 | 3
Title A |  | Location |  | a | a | a
Title A |  | Type |  | a | a | a
Title A |  | Date |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00
Title 1 |  | Location |  | A | A | A
Title 1 |  | Type |  | A | A | A
Title 1 | A | Date 1 |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00
Title 1 | A | Time (months) |  | 1 | 1 | 1
Title 1 | A | Number |  | 1 | 1 | 1
Title 1 | A | [NAME]. |  | x | x | x
Title 1 | B | Date 2 |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00
Title 1 | B | Payoff |  | 2 | 2 | 2
Title 1 | B | Price |  | 5 | 5 | 5
Title 1 | B | Interest |  | 0.01 | 0.01 | 0.01
Title 1 | C | Date 3 |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00
Title 1 | C | Period (months) |  | 3 | 3 | 3
Title 1 | C | Payment |  | 5000 | 5000 | 5000
Title 1 | D | Date 4 |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00
Title 1 | D | Period (months) |  | 1 | 1 | 1
Title 1 | D | Interest |  | 0.01 | 0.01 | 0.01
Title 1 | D | Price |  | 1 | 1 | 1
Title 1 | D | Amount |  | 1 | 1 | 1
Title 2 |  | Location |  | B | B | B
Title 2 |  | Type |  | B | B | B
Title 2 | A | Date 1 |  | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00
Title 2 | A | Time (months) |  | 1 | 1 | 1
Title 2 | A | Number |  | 1 | 1 | 1
Title 2 | A | [NAME]. |  | x | x | x
Title 2 | B | Date 2 |  | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00
Title 2 | B | Payoff
Title 2 | B | Price
Title 2 | B | Interest
Title 2 | C | Date 3 |  | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00
Title 2 | C | Period (months)
Title 2 | C | Payment
Title 2 | D | Date 4 |  | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00
Title 2 | D | Period (months) |  | 2 | 2 | 2
Title 2 | D | Interest |  | 0.02 | 0.02 | 0.02
Title 2 | D | Price |  | 2 | 2 | 2
Title 2 | D | Amount |  | 2 | 2 | 2
Title 3 |  | Location |  | C | C | C
Title 3 |  | Type |  | C | C | C
Title 3 | A | Date 1 |  | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00
Title 3 | A | Time (months) |  | 1 | 1 | 1
Title 3 | A | Number |  | 1 | 1 | 1
Title 3 | A | [NAME]. |  | x | x | x
Title 3 | B | Date 2 |  | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00
Title 3 | B | Payoff
Title 3 | B | Price
Title 3 | B | Interest
Title 3 | C | Date 3 |  | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00
Title 3 | C | Period (months)
Title 3 | C | Payment
Title 3 | D | Date 4 |  | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00
Title 3 | D | Period (months) |  | 3 | 3 | 3
Title 3 | D | Interest |  | 0.03 | 0.03 | 0.03
Title 3 | D | Price |  | 3 | 3 | 3
Title 3 | D | Amount |  | 3 | 3 | 3
Title 4 |  | Location |  | E | E | E
Title 4 |  | Type |  | B | C | B
Title 4 | A | Date 1 |  | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00
Title 4 | A | Time (months) |  | 1 | 1 | 1
Title 4 | A | Number |  | 1 | 1 | 1
Title 4 | A | [NAME]. |  | x | x | x
Title 4 | B | Date 2 |  | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00
Title 4 | B | Payoff
Title 4 | B | Price
Title 4 | B | Interest
Title 4 | C | Date 3 |  | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00
Title 4 | C | Period (months)
Title 4 | C | Payment
Title 4 | D | Date 4 |  | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00
Title 4 | D | Period (months) |  | 4 | 4 | 4
Title 4 | D | Interest |  | 0.04 | 0.04 | 0.04
Title 4 | D | Price |  | 4 | 4 | 4
Title 4 | D | Amount |  | 4 | 4 | 4
Title 5 |  | Location |  | D | D | F
Title 5 |  | Type |  | C | C | B
Title 5 | A | Date 1 |  | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00
Title 5 | A | Time (months) |  | 1 | 1 | 1
Title 5 | A | Number |  | 1 | 1 | 1
Title 5 | A | [NAME]. |  | x | x | x
Title 5 | B | Date 2 |  | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00
Title 5 | B | Payoff
Title 5 | B | Price
Title 5 | B | Interest
Title 5 | C | Date 3 |  | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00
Title 5 | C | Period (months)
Title 5 | C | Payment
Title 5 | D | Date 4 |  | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00
Title 5 | D | Period (months) |  | 5 | 5 | 5
Title 5 | D | Interest |  | 0.05 | 0.05 | 0.05
Title 5 | D | Price |  | 5 | 5 | 5
Title 5 | D | Amount |  | 5 | 5 | 5
Title 6 |  | Location |  |  | F | F
Title 6 |  | Type |  |  | B | B
Title 6 | A | Date 1 |  |  | 2012-05-01 00:00:00 | 2012-06-01 00:00:00
Title 6 | A | Time (months) |  |  | 1 | 1
Title 6 | A | Number |  |  | 1 | 1
Title 6 | A | [NAME]. |  |  | x | x
Title 6 | B | Date 2 |  |  | 2012-05-01 00:00:00 | 2012-06-01 00:00:00
Title 6 | B | Payoff
Title 6 | B | Price
Title 6 | B | Interest
Title 6 | C | Date 3 |  |  | 2012-05-01 00:00:00 | 2012-06-01 00:00:00
Title 6 | C | Period (months)
Title 6 | C | Payment
Title 6 | D | Date 4 |  |  | 2012-05-01 00:00:00 | 2012-06-01 00:00:00
Title 6 | D | Period (months) |  |  | 6 | 6
Title 6 | D | Interest |  |  | 0.06 | 0.06
Title 6 | D | Price |  |  | 6 | 6
Title 6 | D | Amount |  |  | 6 | 6
Assumption | Options
1 | A
2 | B
3 | C