Spreadsheet: 790538d1659775815-cumulative-annualized-return-of-multiple-rows-based-on-multiple-conditions-cumulative-annualized-return-of-multiple-rows-based-on-multiple-conditions
Sheet: josephteh

[NAME] return of multiple rows based on multiple conditions
https://exceljet.net/formula/combine-ranges
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Values to include |  |  |  |  | Dates to include
Name | Fund Name | Units | Unit Purchase Price | Purchase Date | Current Unit Price | Total Purchase Value | Total Current Value | Current Price Date | Years Invested | Annualised Return |  | Name | Fund Name | XIRR Annualised Return |  | Exclude 0 | Combined Value | Total Purchase Value | Total Current Value |  | Exclude 0 | Combined Dates | Purchase Date | Current Price Date
BS | [NAME] Life Flexi Cap | 14.279 | 700.31 | 2018-10-17 00:00:00 | 1197.53 |  |  | 2022-08-05 00:00:00 |  |  |  | BS | [NAME] Life Flexi Cap
BS | [NAME] Life Flexi Cap | 13.454 | 743.29 | 2018-12-03 00:00:00 | 1197.53 |  |  | 2022-08-05 00:00:00 |  |  |  | BS | ICICI Prudential Exports & Services Fund |  |  |  |  | -10000.22366 | 16111.56862 |  |  |  | 2018-12-03 00:00:00 | 2022-08-05 00:00:00
BS | [NAME] Life Flexi Cap | 12.823 | 779.87 | 2020-03-02 00:00:00 | 1197.53 |  |  | 2022-08-05 00:00:00 |  |  |  | PLS | DSP Flexi Cap Fund |  |  |  |  | -10000.27301 | 15355.92719 |  |  |  | 2020-03-02 00:00:00 | 2022-08-05 00:00:00
BS | [NAME] Life Flexi Cap | 17.978 | 556.23 | 2020-04-01 00:00:00 | 1197.53 |  |  | 2022-08-05 00:00:00 |  |  |  | PLS | Nippon India Small Cap Fund |  |  |  |  | -9999.902940000002 | 21529.19434 |  |  |  | 2020-04-01 00:00:00 | 2022-08-05 00:00:00
BS | [NAME] Life Flexi Cap | 15.867 | 630.23 | 2020-05-04 00:00:00 | 1197.53 |  |  | 2022-08-05 00:00:00 |  |  |  | Total |  |  |  |  |  | -9999.859410000001 | 19001.20851 |  |  |  | 2020-05-04 00:00:00 | 2022-08-05 00:00:00
PLS | DSP Flexi Cap Fund | 277.367 | 72.103 | 2021-09-28 00:00:00 | 68.304 |  |  | 2022-08-05 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 00:00:00 | 00:00:00
PLS | DSP Flexi Cap Fund | 271.07 | 73.778 | 2021-10-27 00:00:00 | 68.304 |  |  | 2022-08-05 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 00:00:00 | 00:00:00
PLS | DSP Flexi Cap Fund | 283.152 | 70.63 | 2021-11-30 00:00:00 | 68.304 |  |  | 2022-08-05 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 00:00:00 | 00:00:00
BS | ICICI Prudential Exports & Services Fund | 104.888 | 47.67 | 2015-11-23 00:00:00 | 98.73 |  |  | 2022-08-05 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 00:00:00 | 00:00:00
BS | ICICI Prudential Exports & Services Fund | 419.903 | 47.63 | 2015-11-26 00:00:00 | 98.73 |  |  | 2022-08-05 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 00:00:00 | 00:00:00
PLS | Nippon India Small Cap Fund | 210.728 | 94.9042 | 2022-04-27 00:00:00 | 94.1877 |  |  | 2022-08-05 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 00:00:00 | 00:00:00
PLS | Nippon India Small Cap Fund | 235.059 | 85.0806 | 2022-02-27 00:00:00 | 94.1877 |  |  | 2022-08-05 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 00:00:00 | 00:00:00
PLS | Nippon India Small Cap Fund | 233.709 | 85.5723 | 2022-01-29 00:00:00 | 94.1877 |  |  | 2022-08-05 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 00:00:00 | 00:00:00
PLS | Nippon India Small Cap Fund | 218.518 | 91.5212 | 2022-01-27 00:00:00 | 94.1877 |  |  | 2022-08-05 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 00:00:00 | 00:00:00