Date Formula

[EvansB2]

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

	A	B	C
1		Cost	Date
2		5000	Mar-19
3		10000	Apr-19
4		15000	Aug-19
5
6
7

 

[JimM]

Try

=SUMIFS(B2:B4,C2:C4,">=01/04/2019",C2:C4,"<=31/03/2020")

 

[EvansB2]

Work perfectly,

Thanks for your help,

Ben