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

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

 

[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