Is it possible to use Sumif and Countif in the same formula?

[Oakey]

Hi im looking for a way where i can get a total number of units by a specific date, but not by using a Pivot table.

I then want to be able to manually change the date and the new information will appear.

The data i have is below, Case N. is column A Etc

Case n.	Date	Order n.	Reason	Description	Items	Location n.	No of Units
32827671	20/12/2018		Wrong Item	wrong item	all ok	15f	3
32835020	20/12/2018		Wrong Item	wrong item	black blouse	14e	1
32647334	20/12/2018	no ON	Wrong Item	item purchase in the stor	greey blouse	15d	1
32830784	20/12/2018	no ON	Wrong Item	ITEM purchased in the store	black skirt	10g	1
32654572	20/12/2018			non item	metal blind	fl2	1
32840001	20/12/2018			over45	floral dress	3b	1
32844626	20/12/2018			worn, dirty,smells	sneakeskin dress	2b	1
32786304	20/12/2018			wrong item	black blazer	5f	1
32884421	21/12/2018			faulty item	SNAKESKIN PRINT BODYSUIT	19d	1
32923639	22/12/2018			over 45	all ok	17e	3
32919482	22/12/2018			wrong item	brown blouse	9g	1
33091285	27/12/2018			wrong size	grey trousers	21c	1
33093646	27/12/2018			hole	brown shoes	17h	1
33098935	27/12/2018			item not belongs to the orders	leopard scarf	7d	1
33121778	28/12/2018			dirty on the sleeve,make up on the collar	metalic blouse	20b	1
33135137	28/12/2018			over 45 days	man jacket	16c	1
33172604	29/12/2018			over45	skirt, 2 blouses	20d	3
33181184	29/12/2018			Item from store	white shirt women	6e	1
33172312	29/12/2018			no inner label	leopard trousers	14f	1
	31/12/2018			over45	all ok	9b	5
33212192	31/12/2018			over45	all ok	10d	5
33230450	31/12/2018			items not belongs to the orders	kids shoes	13g	3
33145728	31/12/2018			wrong item	h&m jacket	8c	1
33218362	31/12/2018			wrong size	black shoes	11a	1
33221199	31/12/2018			over45	blouse in panther	6d	1
33257548	02/01/2019			wrong item	skirt women	10c	1

<colgroup><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

 

[JoeMo]

SUMIF should do it:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	Case n.	Date	Order n.	Reason	Description	Items	Location n.	No of Units		Date	Tot Units
2	32827671	20/12/2018		Wrong Item	wrong item	all ok	15f	3		20/12/2018	7
3	32835020	20/12/2018		Wrong Item	wrong item	black blouse	14e	1
4	32647334	20/12/2018	no ON	Wrong Item	item purchase in the stor	greey blouse	15d	1
5	32830784	20/12/2018	no ON	Wrong Item	ITEM purchased in the store	black skirt	10g	1
6	32654572	20/12/2018			non item	metal blind	fl2	1
Sheet3

 

[Oakey]

Thank you, i changed it a little but it now works fine