Dear Excel Gurus,
I am trying to sum with Sumifs based on the date.
please note data is example but in actual list is from last 5 years.
I am looking for Sum based on date an year condition.
For example: Sum only all Apple from current date to last 2 year only if year is 2. same Sum only Mango from current date or month to last 3 year is year is 3... soon.
looking for support.
I am trying to sum with Sumifs based on the date.
Type | Date | Year |
Apple | 01.01.2020 | 2 |
Apple | 01.05.2020 | 2 |
Mango | 01.01.2020 | 3 |
Mango | 01.01.2019 | 3 |
Apple | 01.01.2019 | 2 |
Mango | 01.01.2018 | 3 |
Banana | 01.01.2018 | 5 |
please note data is example but in actual list is from last 5 years.
I am looking for Sum based on date an year condition.
For example: Sum only all Apple from current date to last 2 year only if year is 2. same Sum only Mango from current date or month to last 3 year is year is 3... soon.
looking for support.