Formula to work out monthly spends

[HAYLO22]

Hi.

I am creating a spreadsheet to workout the annual expenditure for a business.

I have a table which will hold all spends throughout the year, I would like to create another table so that the information is separated into monthly spends.

I have added an image of the spreadsheet so far. I have inputted dates to the side to help me with my formula, but I am not having any joy with getting the formula right.

I would like the formula to go into B2 for April and so on.

Thank you.

 

[Peter_SSs]

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

Something like this?

23 08 04.xlsm
	A					F	G							N	O	P	Q
6															1/04/2023	30/04/2023	506
7	1/04/2023					500									1/05/2023	31/05/2023	23
8	15/04/2023					1									1/06/2023	30/06/2023	56
9	25/05/2023					23									1/07/2023	31/07/2023	0
10	1/06/2023					56
11	5/04/2023					5
Monthly spends

Cell Formulas
Range	Formula
Q6:Q9	Q6	=SUMIFS(F$7:F$20,A$7:A$20,">="&O6,A$7:A$20,"<="&P6)

 

[HAYLO22]

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

Something like this?

23 08 04.xlsm
	A					F	G							N	O	P	Q
6															1/04/2023	30/04/2023	506
7	1/04/2023					500									1/05/2023	31/05/2023	23
8	15/04/2023					1									1/06/2023	30/06/2023	56
9	25/05/2023					23									1/07/2023	31/07/2023	0
10	1/06/2023					56
11	5/04/2023					5
Monthly spends

Cell Formulas
Range	Formula
Q6:Q9	Q6	=SUMIFS(F$7:F$20,A$7:A$20,">="&O6,A$7:A$20,"<="&P6)

Thank you for that, that worked perfectly.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.