Multiple count if formula?

[Oakey]

Hi,
Im looking to create a daily sheet that can show me how many cases an operative opens / closes in a day from a master sheet of data.
Im looking for a countIf formula i think, but think it needs to count the number of 'Open' cases that appear with a specific date and username.

Screen shot of the date below

Case n.

Date

Order n.

Reason

Description

Items

No Units

Location

Closed

Response needed by

Who create case

Who closed the case

Resolution

Agree with CS

Date closed

46041442

06/01/2020

51911531550

Worn item

missing item

belt

1

8f

Open

21/01/2020

Kasia

yes

45967427

06/01/2020

51943072588

Worn item

missing package

headband

1

b2

Open

21/01/2020

Kasia

yes

46072476

06/01/2020

51850157756

Over 40 days

good condition

all ok

2

2e

Open

21/01/2020

Kasia

yes

46035751

06/01/2020

51929369412

Worn item

pulled threads

blouse

1

24F

Open

21/01/2020

Christina

Yes

46059742

06/01/2020

51937972262

Missing Item

incomplete item

belt

1

D1

Open

21/01/2020

Christina

Yes

46064987

06/01/2020

51952639980

Worn item

dirty

trousers

1

21F

Open

21/01/2020

Christina

Yes

45986845

06/01/2020

51872647348

Worn item

strange smells

trousers

1

13i

Open

21/01/2020

Paulina

Yes

45881181

06/01/2020

51952557360

Wrong Item

different size

shoes

1

19b

Open

21/01/2020

Paulina

Yes

45986176

06/01/2020

51952559086

Worn item

smells

women clothes

2

17e

Open

21/01/2020

Paulina

Yes

46066350

06/01/2020

51942207088

Worn item

not refundable

underwear

1

20g

Open

21/01/2020

Paulina

Yes

46074707

06/01/2020

51882665172

Over 40 days

good condition

coat

1

18d

Open

21/01/2020

Paulina

Yes

46107574

07/01/2020

51911971748

Worn item

no inner and external label

jeans

1

17h

Open

22/01/2020

Paulina

Yes

46109163

07/01/2020

51952747488

Worn item

not refundable

underwear

1

13g

Open

22/01/2020

Paulina

Yes

46122921

07/01/2020

51847304904

Over 40 days

good condition

jeans

1

15f

Open

22/01/2020

Paulina

Yes

46124272

07/01/2020

51937125688

Worn item

no inner and external label

knit top

1

15g

Open

22/01/2020

Paulina

Yes

46103340

07/01/2020

51950382342

Worn item

sweat smell

sequin dress

1

9g

Open

22/01/2020

weronika

Yes

Can anyone help me with this formulas please?

Thanks is advance

 

[Eric W]

Try COUNTIFS:

Book1
	Q	R	S	T
1	Date	Name	Status	Count
2	6/1/2020	Paulina	Open	5
Sheet5

Cell Formulas
Range	Formula
T2	T2	=COUNTIFS(B:B,Q2,I:I,S2,K:K,R2)

 

[Oakey]

Thank you Eric.

 

[Eric W]

You're welcome.