Hi there,
I'm trying to sum certain values that fall within set Date criteria. So using the example below, in cell B6, I would like to only sum those values in column B that fall between the period Apr-19 to Mar-20. So in this case this would be 25,000.
Any assistance would be gratefully received.
Ben
I'm trying to sum certain values that fall within set Date criteria. So using the example below, in cell B6, I would like to only sum those values in column B that fall between the period Apr-19 to Mar-20. So in this case this would be 25,000.
Any assistance would be gratefully received.
Ben
A | B | C | |
1 | Cost | Date | |
2 | 5000 | Mar-19 | |
3 | 10000 | Apr-19 | |
4 | 15000 | Aug-19 | |
5 | |||
6 | |||
7 |