Sumif/s with Date Criteria

[Sundance_Kid]

Hi,

I am looking to do a sumif/s formula but using dates as the criteria.

I won't have a helper column with the start and end date. So, it would need to be something manually entered in the formula, an example for April being 01/04/2023 to 30/04/2023.

Is it possible?

Thanks

 

[Fluff]

You can do that like

=SUMIFS(B:B,A:A,">="&DATE(2023,4,1),A:A,"<"&DATE(2023,5,1))

 

[Sundance_Kid]

You can do that like

=SUMIFS(B:B,A:A,">="&DATE(2023,4,1),A:A,"<"&DATE(2023,5,1))

Thanks, I couldn't quite get it to work.

See the attached image, how would the formula work here if trying to sum up any amounts in April?

 

[kevin9999]

@Fluff 's formula is correct, it would have helped to see which columns your data was in though...

Book1
	B	C	D	E
3	Date	Total
4	01/07/2020	35		70
5	01/06/2020	30
6	25/04/2023	25
7	09/04/2023	20
8	08/04/2023	15
9	01/04/2023	10
Sheet1

Cell Formulas
Range	Formula
E4	E4	=SUMIFS(C:C,B:B,">="&DATE(2023,4,1),B:B,"<"&DATE(2023,5,1))