sumif between two dates

[Seifeddine87]

hi just looking for a way how i can sum an amount based on the Description and between two dates
Example:

	A	B	C	D	E	F	G	H
1	01/09/2021	30/09/2021				Date	Description
2	Description					01/08/2021	Stock and materials	£1600
3	Postage	=??????				05/08/2021	Rent	£1200
4	Stock and materials	£3000				03/09/2021	Stock and materials	£600
5	Rent	£1200				08/09/2021	Rent	£1200
6	Business rates	£0				09/09/2021	Postage	£500
7	Cleaning and repairs	£0				11/09/2021	Postage	£800
8						13/09/2021	Stock and materials	£2400
9

 

[Fluff]

You have NOT made the change I suggested, which is why it's not working.

 

[Seifeddine87]

You have NOT made the change I suggested, which is why it's not working.

i apologise about the misunderstood i just copied it and passed it im not very good in excel ?

 

[Seifeddine87]

You have NOT made the change I suggested, which is why it's not working.

i will just change G1 instead of 01/05/2021 to 30/04/2021 it should work perfect do you think?

 

[Fluff]

You can do that, but why not just include the = sign in the formula, like I showed?

 

[Seifeddine87]

You can do that, but why not just include the = sign in the formula, like I showed?

oh yes i just got what you mean thank you ?

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Seifeddine87]

Glad we could help & thanks for the feedback.

yes works perfect now thank you for your help and for been patent with me