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

 

[ClaireS]

=SUMIFS($H$2:$H$8,$G$2:$G$8,A4,$F$2:$F$8,">="&$A$1,$F$2:$F$8,"<="&$B$1)

 

[Seifeddine87]

=SUMIFS($H$2:$H$8,$G$2:$G$8,A4,$F$2:$F$8,">="&$A$1,$F$2:$F$8,"<="&$B$1)

thank you for your reply for some reason it didn't work
=SUMIFS(Outcome!$I$2:$I$1001,Outcome!$D$2:$D$1001,B7,Outcome!$B$2:$B$1001,">"&$G$1,Outcome!$B$2:$B$1001,"<="&$H$1)

 

[Seifeddine87]

thank you for your reply for some reason it didn't work
=SUMIFS(Outcome!$I$2:$I$1001,Outcome!$D$2:$D$1001,B7,Outcome!$B$2:$B$1001,">"&$G$1,Outcome!$B$2:$B$1001,"<="&$H$1)

 

[Fluff]

It should be

=SUMIFS(Outcome!$I$2:$I$1001,Outcome!$D$2:$D$1001,B7,Outcome!$B$2:$B$1001,">="&$G$1,Outcome!$B$2:$B$1001,"<="&$H$1)

 

[Seifeddine87]

It should be

=SUMIFS(Outcome!$I$2:$I$1001,Outcome!$D$2:$D$1001,B7,Outcome!$B$2:$B$1001,">="&$G$1,Outcome!$B$2:$B$1001,"<="&$H$1)

it did worked when i changed the date to 02/05/2021 it doesnt work on 01/05/2021

 

[Fluff]

Did you make the change I suggested?

 

[Seifeddine87]

yes i did the change u suggested and it is the same as claire suggested it does work only when the date 02/05/2021 or more

 

[Seifeddine87]

yes i did the change u suggested and it is the same as claire suggested it does work only when the date 02/05/2021 or mor

 

[Seifeddine87]

Did you make the change I suggested?